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