Hi all,
BACKGROUND:
However I am now upgrading to Firebird 3.0.7, and I want to DROP those fields using this custom DOMAIN and replace with the native boolean type. All of this is being done programmatically when the application starts. To do this, I am simply ALTERing the various TABLEs by ADDing new COLUMNs, copying over the values, DROPping the old COLUMNs, and renaming the natively-typed boolean columns back to the original name. All of this works fine, except...
PROBLEM:
When I come to committing the transaction, it fails with an error stating that there are dependencies. This is because of a large, unwieldy PROCEDURE that uses those COLUMNs that are being touched. Experimenting and DROPing the PROCEDURE sees the dependency error disappear and the transaction succeeds. Re-creating this procedure is not an option.
QUESTION:
So is there a way to temporarily turn off this kind of dependency checking? Then I could run my script, and turn it back on again.
Thanks in advance for your help.
Best regards,
David