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

On 9/13/17 09:25, Alvaro Herrera wrote:
> Tom Lane wrote:
>> "David G. Johnston"  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.

-- 
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