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! From: mailto:[email protected] Sent: Thursday, August 28, 2014 6:02 PM To: [email protected] 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
