Re: DERBY-6303: Add ability to defer enforcement of unique indexes until transaction end

2024-02-01 Thread Bart van der Bilt
On 2/1/24 00:51, Rick Hillegas wrote: When I run fxmovierentals6-all.sql, I get a violation of a different foreign key than the one mentioned in the comment at the end of the script. I get this error: ERROR 23516: The transaction was aborted because of a deferred constraint violation:

[jira] [Commented] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

2024-02-01 Thread Bart van der Bilt (Jira)
[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813401#comment-17813401 ] Bart van der Bilt commented on DERBY-6303: -- After fixing the data this works great :). Create

[jira] [Updated] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

2024-02-01 Thread Bart van der Bilt (Jira)
[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bart van der Bilt updated DERBY-6303: - Attachment: (was: fxmovierentals6-all.sql) > Add ability to defer enforcement of

[jira] [Updated] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

2024-02-01 Thread Bart van der Bilt (Jira)
[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bart van der Bilt updated DERBY-6303: - Attachment: movies_insert_fk7.sql > Add ability to defer enforcement of unique indexes

[jira] [Updated] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

2024-02-01 Thread Bart van der Bilt (Jira)
[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bart van der Bilt updated DERBY-6303: - Attachment: movierentals26.sql > Add ability to defer enforcement of unique indexes

[jira] [Updated] (DERBY-6303) Add ability to defer enforcement of unique indexes until transaction end.

2024-02-01 Thread Bart van der Bilt (Jira)
[ https://issues.apache.org/jira/browse/DERBY-6303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bart van der Bilt updated DERBY-6303: - Attachment: (was: movies_insert_fk7.sql) > Add ability to defer enforcement of