Hubert FONGARNAND wrote: > Hi, > > Is there a way to temporary disable a constraint (without drop and > recreating it) in postgresql?
Sure, try ALTER TABLE ... DISABLE TRIGGER for the constraint trigger name. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq