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

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.

-- 
Álvaro Herrera                https://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