Subject Re: [firebird-support] "DROP CONSTRAINT" only shows effect after commit?
Author Martijn Tonies (Upscene Productions)
Post date 2014-08-28T16:08:51Z
Hello Patrick,
 
Yes, that is correct, meta data changes need to be committed as well.
 
With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
 
 
Sent: Thursday, August 28, 2014 6:02 PM
Subject: [firebird-support] "DROP CONSTRAINT" only shows effect after commit?
 


Hello,

any attempt to do a search ends with the screen

Oops!
Polls feature not enabled


for some reason, so I have to ask directly:

Is it correct, that a commit is required after some contraints have been removed, before I can do some data changes which would violate those constraints?


Hoped to do it in one transaction, but I'm getting a violation error for one of the removed contraints when inserting some data, although a check via RDB$RELATION_CONSTRAINTS says the constraint isn't there anymore...


Best regards,

Patrick