"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
rch 19, 2001 10:53 AM
> To: Hackers
> Subject: [HACKERS] Dropping CHECK constraints
>
>
> In 7.0.3, is it safe to drop a check constraint by simply deleting it from
> the pg_relcheck table?
>
> Chris
>
> --
> Christopher Kings-Lynne
> Family Health Network (ACN 08
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 drop a check constraint by simply deleting it from
the pg_relcheck table?
Chris
--
Christopher Kings-Lynne
Family Health Network (ACN 089 639 243)
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please s