Discussion:
[Liquibase-user] Adding a foreign key constraint with delete cascade option
Alan Savage
2007-09-05 23:24:46 UTC
Permalink
Hello,

Is there anyway to specify the "delete cascade" option when adding a new
foreign key to an existing table? I see the <constraints> tag supports a
deleteCascade attribute, but I don't see such an option for
<addForeignKeyConstraint>.

Alan


The information contained in this email may be confidential and/or legally privileged. It has been sent for the sole use of the intended recipient(s). If the reader of this message is not an intended recipient, you are hereby notified that any unauthorized review, use, disclosure, dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. Thank you
Nathan Voxland
2007-09-06 17:41:09 UTC
Permalink
You're right. We had missed that. The fix has been added for 1.3.

I also noticed that the deleteCascade attribute was being ignored for
the createTable change, so that has been fixed.

Nathan

-----Original Message-----
From: liquibase-user-***@lists.sourceforge.net
[mailto:liquibase-user-***@lists.sourceforge.net] On Behalf Of Alan
Savage
Sent: Wednesday, September 05, 2007 6:25 PM
To: liquibase-***@lists.sourceforge.net
Subject: [Liquibase-user] Adding a foreign key constraint with
deletecascade option

Hello,

Is there anyway to specify the "delete cascade" option when adding a new
foreign key to an existing table? I see the <constraints> tag supports a
deleteCascade attribute, but I don't see such an option for
<addForeignKeyConstraint>.

Alan


The information contained in this email may be confidential and/or
legally privileged. It has been sent for the sole use of the intended
recipient(s). If the reader of this message is not an intended
recipient, you are hereby notified that any unauthorized review, use,
disclosure, dissemination, distribution, or copying of this
communication, or any of its contents, is strictly prohibited. If you
have received this communication in error, please contact the sender by
reply email and destroy all copies of the original message. Thank you



------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
Alan Savage
2007-09-07 14:49:30 UTC
Permalink
Thanks! I appreciate your help.

Alan

-----Original Message-----
From: Nathan Voxland [mailto:***@sundog.net]
Sent: Thursday, September 06, 2007 12:41 PM
To: Alan Savage; liquibase-***@lists.sourceforge.net
Subject: RE: [Liquibase-user] Adding a foreign key constraint with
deletecascade option

You're right. We had missed that. The fix has been added for 1.3.

I also noticed that the deleteCascade attribute was being ignored for
the createTable change, so that has been fixed.

Nathan

-----Original Message-----
From: liquibase-user-***@lists.sourceforge.net
[mailto:liquibase-user-***@lists.sourceforge.net] On Behalf Of Alan
Savage
Sent: Wednesday, September 05, 2007 6:25 PM
To: liquibase-***@lists.sourceforge.net
Subject: [Liquibase-user] Adding a foreign key constraint with
deletecascade option

Hello,

Is there anyway to specify the "delete cascade" option when adding a new
foreign key to an existing table? I see the <constraints> tag supports a
deleteCascade attribute, but I don't see such an option for
<addForeignKeyConstraint>.

Alan


The information contained in this email may be confidential and/or
legally privileged. It has been sent for the sole use of the intended
recipient(s). If the reader of this message is not an intended
recipient, you are hereby notified that any unauthorized review, use,
disclosure, dissemination, distribution, or copying of this
communication, or any of its contents, is strictly prohibited. If you
have received this communication in error, please contact the sender by
reply email and destroy all copies of the original message. Thank you



------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Liquibase-user mailing list
Liquibase-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/liquibase-user


The information contained in this email may be confidential and/or legally privileged. It has been sent for the sole use of the intended recipient(s). If the reader of this message is not an intended recipient, you are hereby notified that any unauthorized review, use, disclosure, dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. Thank you
Continue reading on narkive:
Search results for '[Liquibase-user] Adding a foreign key constraint with delete cascade option' (Questions and Answers)
4
replies
Oracle SQL: Delete Rows with Foreign Key Constraints?
started 2010-12-04 14:17:37 UTC
programming & design
Loading...