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

From David G. Johnston
Subject Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqencename for IDENTITY columns
Date
Msg-id CAKFQuwaaJLpiHKCj7W8FS6rwmd2YgyNYbnA2qyMeM+ukKnN=hA@mail.gmail.com
Whole thread Raw
In response to [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name forIDENTITY columns  (zam6ak@gmail.com)
Responses Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqencename for IDENTITY columns
Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns
List pgsql-bugs
On Tue, Sep 12, 2017 at 2:20 PM, <zam6ak@gmail.com> wrote:
The following bug has been logged on the website:

Bug reference:      14813
Logged by:          zam zam
Email address:      zam6ak@gmail.com
PostgreSQL version: 10beta4
Operating system:   windows
Description:

Function pg_get_serial_sequence returns NULL on columns defined as
IDENTITY

CREATE TABLE IF NOT EXISTS public.test (
    id     bigint  NOT NULL GENERATED ALWAYS AS IDENTITY,
    code   text,

    CONSTRAINT test_pk   PRIMARY KEY (id)
)

SELECT pg_get_serial_sequence('public.test', 'id'); -- returns NULL instead
of 'test_id_seq'!

​I suspect this is an opportunity for documentation enhancement as opposed to a bug.

​The CREATE TABLE docs say that: "It will have an implicit sequence attached to it."  I take the word "implicit" to mean that an actual external sequence object is not created.

David J.

pgsql-bugs by date:

Previous
From: zam6ak@gmail.com
Date:
Subject: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name forIDENTITY columns
Next
From: zambak zambak
Date:
Subject: Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqencename for IDENTITY columns