Re: BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: zam6ak(at)gmail(dot)com, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns
Date: 2017-09-12 23:47:39
Message-ID: 31137.1505260059@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Tue, Sep 12, 2017 at 2:20 PM, <zam6ak(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pengchong 2017-09-13 07:13:13 about pgcrypto, not support "des"
Previous Message Wong, Yi Wen 2017-09-12 23:29:25 Re: Old row version in hot chain become visible after a freeze