Doh! Not reltriggers - I meant relchecks...
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Christopher
Kings-Lynne
Sent: Monday, March 19, 2001 10:53 AM
To: Hackers
Subject: [HACKERS] Dropping CHECK constraints
In 7.0.3, is it safe to
OK, I notice I have to decrement the reltriggers field in the pg_class
directory as well, but other than that is there any problem?
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Christopher
Kings-Lynne
Sent: Monday, March 19, 2001 10:53 AM
"Christopher Kings-Lynne" [EMAIL PROTECTED] writes:
In 7.0.3, is it safe to drop a check constraint by simply deleting it from
the pg_relcheck table?
You'll need to adjust the relchecks count in the table's pg_class entry
as well.
regards, tom lane