Re: [HACKERS] Dropping CHECK constraints

2001-03-18 Thread Tom Lane
"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

RE: [HACKERS] Dropping CHECK constraints

2001-03-18 Thread Christopher Kings-Lynne
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

RE: [HACKERS] Dropping CHECK constraints

2001-03-18 Thread Christopher Kings-Lynne
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

[HACKERS] Dropping CHECK constraints

2001-03-18 Thread Christopher Kings-Lynne
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