Hi,
Just passing by:
http://issues.apache.org/jira/browse/DERBY-735
Regards,
- Sylvain
Gabriele Kahlout a écrit :
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 <[email protected]>:
On 3/15/10 6:46 PM, "Ronald Rudy" <[email protected]> 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
[email protected]
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
--
[email protected]
http://www.chicoree.fr