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

From: zam6ak(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: zam6ak(at)gmail(dot)com
Subject: BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns
Date: 2017-09-12 21:20:54
Message-ID: 20170912212054.25640.55202@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14813
Logged by: zam zam
Email address: zam6ak(at)gmail(dot)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'!

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2017-09-12 21:54:45 Re: BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns
Previous Message Wong, Yi Wen 2017-09-12 20:54:58 Re: Old row version in hot chain become visible after a freeze