Feedback-ID: ie0a040ee:Fastmail
Message-ID: <4970adf1-cdb0-9ae5-d405-e9c3395d9931@eisentraut.org>
Date: Tue, 12 Sep 2023 09:33:54 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0)
 Gecko/20100101 Thunderbird/102.15.0
Subject: Re: Adding a pg_get_owned_sequence function?
Content-Language: en-US
To: =?UTF-8?Q?Dagfinn_Ilmari_Manns=c3=a5ker?= <ilmari@ilmari.org>,
 pgsql-hackers@postgresql.org
References: <87jzwcsasv.fsf@wibble.ilmari.org>
From: Peter Eisentraut <peter@eisentraut.org>
In-Reply-To: <87jzwcsasv.fsf@wibble.ilmari.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/4970adf1-cdb0-9ae5-d405-e9c3395d9931%40eisentraut.org>
Precedence: bulk

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?