Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns
Date
Msg-id 31137.1505260059@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqencename for IDENTITY columns  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [BUGS] BUG #14813: pg_get_serial_sequence does not returnseqence name for IDENTITY columns
List pgsql-bugs
Tree view 
"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 by date:

Previous
From: "Wong, Yi Wen"
Date:
Subject: Re: [BUGS] Old row version in hot chain become visible after a freeze
Next
From: "pengchong"
Date:
Subject: [BUGS] about pgcrypto, not support "des"