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

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqencename for IDENTITY columns
Дата
Msg-id be99f778-2c0b-87d6-3772-008d8ac8e9e7@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqencename for IDENTITY columns  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-bugs
On 9/14/17 17:15, Peter Eisentraut wrote:
> On 9/13/17 09:25, Alvaro Herrera wrote:
>> Tom Lane wrote:
>>> "David G. Johnston" <david.g.johnston@gmail.com> writes:
>>
>>>> ​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.
>>
>> It would be bad to break queries all over the internet that assume that
>> sequences for columns can be found using pg_get_serial_sequence, so I
>> agree this should be fixed.
> 
> Proposed patch attached.

committed

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: [BUGS] Urgent! PGWatch issue
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14808: V10-beta4, backend abort