Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqencename for IDENTITY columns

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqencename for IDENTITY columns
Дата
Msg-id CAKFQuwaaJLpiHKCj7W8FS6rwmd2YgyNYbnA2qyMeM+ukKnN=hA@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name forIDENTITY columns  (zam6ak@gmail.com)
Ответы Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqencename for IDENTITY columns  (zambak zambak <zam6ak@gmail.com>)
Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: zam6ak@gmail.com
Дата:
Сообщение: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name forIDENTITY columns
Следующее
От: zambak zambak
Дата:
Сообщение: Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqencename for IDENTITY columns