Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Disable constraint [CORE1924] #2358

Open
firebird-automations opened this issue Jun 6, 2008 · 1 comment
Open

Disable constraint [CORE1924] #2358

firebird-automations opened this issue Jun 6, 2008 · 1 comment

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @cincuranet

Votes: 14

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

This more or less similar to CORE1084, but with wider application.

@firebird-automations
Copy link
Collaborator Author

Commented by: Mark Stein (mark stein)

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant