Re: how do I DROP this CONSTRAINT?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: how do I DROP this CONSTRAINT?
Дата
Msg-id 12460.982682609@sss.pgh.pa.us
обсуждение исходный текст
Ответ на how do I DROP this CONSTRAINT?  (Alexey Borzov <borz_off@rdw.ru>)
Список 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 по дате отправления:

Предыдущее
От: "Brett W. McCoy"
Дата:
Сообщение: Re: Re: binding postmaster to *one* virtual IP address
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: vacuum analyze again...