Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: <C7C43200.180DA%rgenter@silverlink.com>
References: <F81DAA4E-715E-4CD2-A122-B43FDEB39881@gmail.com>
	 <C7C43200.180DA%rgenter@silverlink.com>
Date: Tue, 16 Mar 2010 06:07:32 +0100
Message-ID: <1f5d398f1003152207p46d5dc12g5af672b19de5edb3@mail.gmail.com>
Subject: Re: how to cascade on update? Not possible?
From: Gabriele Kahlout <gabriele@mysimpatico.com>
To: Derby Discussion <derby-user@db.apache.org>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

ya. Also SQLite does.
I tried to look where to submit feature requests (not bug reports),
but failed. Any links?

2010/3/16, Rick Genter <rgenter@silverlink.com>:
> On 3/15/10 6:46 PM, "Ronald Rudy" <ronchalant@gmail.com> wrote:
>
>> I believe you want to look at this:
>> http://db.apache.org/derby/manuals/reference/sqlj32.html
>>
>>  <http://db.apache.org/derby/manuals/reference/sqlj32.html> Specifically
>> the
>> referential ON UPDATE in constraints.  The only "ON UPDATE" actions that
>> are
>> allowed are "NO ACTION" and "RESTRICT"; Derby does not appear to support
>> cascading updates.  You can log a feature request, I believe there might
>> already be one for it based on this thread:
>> http://old.nabble.com/ON-UPDATE-CASCADE-in-derby-td1633870.html
>>
>> Incidentally I do believe that MySQL supports on update cascade with its
>> INNODB engine, and I do think MS SQL does as well
>> (http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx)
>>
> Thank you for the pointer. I learn something new every day ;-).
> --
> Rick Genter
> Principal Software Engineer
> Silverlink Communications
> rgenter@silverlink.com
> www.silverlink.com
> Office (781) 583-7145
> Mobile (408) 398-7006
>
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may only be used by the person or entity to
> which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified
> that any dissemination, distribution or copying of this e-mail is
> prohibited. If you have received this e-mail in error, please notify the
> sender by replying to this message and delete this e-mail immediately
>
>


--=20
Regards,
K. Gabriele

--- unchanged since 25/1/10 ---
P.S. Unless a notification (LON), please reply either with an answer
OR with " ACK" appended to this subject within 48 hours. Otherwise, I
might resend.
In(LON, this) =E2=88=A8 In(48h, TimeNow) =E2=88=A8 =E2=88=83x. In(x, MyInbo=
x) =E2=88=A7 IsAnswerTo(x,
this) =E2=88=A8 (In(subject(this), subject(x)) =E2=88=A7 In(ACK, subject(x)=
) =E2=88=A7
=C2=ACIsAnswerTo(x,this)) =E2=87=92 =C2=ACIResend(this).

Also note that correspondence may be received only from specified a
priori senders, or if the subject of this email ends with a code, eg.
-LICHT01X, then also from senders whose reply contains it.
=E2=88=80x. In(x, MyInbox) =E2=87=92 In(senderAddress(x), MySafeSenderList)=
 =E2=88=A8 (=E2=88=83y.
In(y, subject(this) ) =E2=88=A7 In(y,x) =E2=88=A7 isCodeLike(y, -LICHT01X) =
).