Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns
Дата
Msg-id 31137.1505260059@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqencename for IDENTITY columns  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [BUGS] BUG #14813: pg_get_serial_sequence does not returnseqence name for IDENTITY columns  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-bugs
Дерево обсуждения 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tue, Sep 12, 2017 at 2:20 PM, <zam6ak@gmail.com> wrote:
>> Function pg_get_serial_sequence returns NULL on columns defined as
>> IDENTITY

This seems like a reasonable complaint to me.

> ​I suspect this is an opportunity for documentation enhancement as opposed
> to a bug.

The reason appears to be that the dependency setup for a sequence created
to support IDENTITY is randomly different from that for a serial sequence.
I'm not sure this is a good thing.
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: "Wong, Yi Wen"
Дата:
Сообщение: Re: [BUGS] Old row version in hot chain become visible after a freeze
Следующее
От: "pengchong"
Дата:
Сообщение: [BUGS] about pgcrypto, not support "des"