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
Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns |
| Список | pgsql-bugs |
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 по дате отправления: