Re: how do I DROP this CONSTRAINT? - Mailing list pgsql-general

From Tom Lane
Subject Re: how do I DROP this CONSTRAINT?
Date
Msg-id 12460.982682609@sss.pgh.pa.us
Whole thread Raw
In response to how do I DROP this CONSTRAINT?  (Alexey Borzov <borz_off@rdw.ru>)
List pgsql-general
Alexey Borzov <borz_off@rdw.ru> writes:
>    Can I just delete the record in pg_relcheck, decrement the counter
> in pg_class and enjoy the results or will it have undesirable
> side-effects?

Should work; be careful to do the pg_class change last, else you'll
likely get inconsistency complaints.  IIRC, the pg_class change will
trigger relation-cache reload for the table, and the indicated number
of records had better match pg_relcache when that happens.

            regards, tom lane

pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: Re: binding postmaster to *one* virtual IP address
Next
From: Bruce Momjian
Date:
Subject: Re: vacuum analyze again...