Re: BUG #1883: Renaming a schema leaves inconsistent sequence

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1883: Renaming a schema leaves inconsistent sequence
Дата
Msg-id 28761.1127442561@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #1883: Renaming a schema leaves inconsistent sequence  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: BUG #1883: Renaming a schema leaves inconsistent sequence  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: BUG #1883: Renaming a schema leaves inconsistent sequence  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-bugs
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> This item has been added to the 8.1 bugs list:
>     http://momjian.postgresql.org/cgi-bin/pgbugs

This isn't going to be fixed for 8.1.  I think it's really a variant of
the TODO item
    o %Have ALTER TABLE RENAME rename SERIAL sequence names

To my mind the appropriate fix is to come up with some arrangement
that allows the stored form of NEXTVAL(seq) to specify the referenced
sequence directly (by OID) rather than as a text string.  There are some
speculations about this in the archives, but no really workable solution
yet.

(wanders off, wondering if a "regclass" literal value would help ...)

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #1883: Renaming a schema leaves inconsistent sequence
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #1883: Renaming a schema leaves inconsistent sequence