Issue Details (XML | Word | Printable)

Key: CORE-1924
Type: New Feature New Feature
Status: Open Open
Priority: Minor Minor
Assignee: Unassigned
Reporter: Jiri Cincura
Votes: 14
Watchers: 6
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Disable constraint

Created: 06/Jun/08 10:31 AM   Updated: 02/Mar/10 01:35 PM
Component/s: None
Affects Version/s: None
Fix Version/s: None


 Description  « Hide
Temporaly disabling constraints (FK, check, ...) using:
ALTER TABLE <table> DISABLE <constraint> and ALTER TABLE <table> ENABLE <constraint>

This more or less similar to CORE-1084, but with wider application.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Stein added a comment - 02/Mar/10 01:35 PM
It would be great to have such a functionality!

I'm looking for a way do achieve that, but can't find anything.

This article:
http://www.firebirdfaq.org/faq20/

says "[...]Alternatively, you can disable the constraints during the import and turn them back on later.[...]"

so it seems to be possible. I would like to know how.

Can anyone help me with this please?

If this is not possible yet, then please consider it for one of the next releases.

Thanks,
Mark