Re: Adding a pg_get_owned_sequence function? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Adding a pg_get_owned_sequence function?
Date
Msg-id 4970adf1-cdb0-9ae5-d405-e9c3395d9931@eisentraut.org
Whole thread Raw
In response to Adding a pg_get_owned_sequence function?  (Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>)
Responses Re: Adding a pg_get_owned_sequence function?
List pgsql-hackers
On 09.06.23 21:19, Dagfinn Ilmari Mannsåker wrote:
> I've always been annoyed by the fact that pg_get_serial_sequence takes
> the table and returns the sequence as strings rather than regclass. And
> since identity columns were added, the name is misleading as well (which
> is even acknowledged in the docs, together with a suggestion for a
> better name).

If you are striving for less misleading terminology, note that the 
concept of an "owned sequence" does not exist for users of identity 
sequences, and ALTER SEQUENCE / OWNED BY cannot be used for such sequences.

Would it work to just overload pg_get_serial_sequence with regclass 
argument types?




pgsql-hackers by date:

Previous
From: 쿼리트릭스
Date:
Subject: Re: [ psql - review request ] review request for \d+ tablename, \d+ indexname indenting
Next
From: Peter Eisentraut
Date:
Subject: Re: proposal: psql: show current user in prompt