From: | Dagfinn Ilmari Mannsåker <ilmari(at)ilmari(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Adding a pg_get_owned_sequence function? |
Date: | 2023-06-09 19:19:44 |
Message-ID: | 87jzwcsasv.fsf@wibble.ilmari.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi hackers,
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).
So, instead of making excuses in the documentation, I thought why not
add a new function which addresses all of these issues, and document the
old one as a backward-compatibilty wrapper?
Please see the attached patch for my stab at this.
- ilmari
Attachment | Content-Type | Size |
---|---|---|
0001-Add-pg_get_owned_sequence-function.patch | text/x-diff | 10.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2023-06-09 19:23:36 | Re: Cleaning up nbtree after logical decoding on standby work |
Previous Message | Joe Conway | 2023-06-09 19:05:40 | Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG |