pg_get_serial_sequence

Started by Christopher Kings-Lynneover 22 years ago2 messagespatches
Jump to latest
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

Hi,

Attached is a new backend function, pg_get_serial_sequence. It allows
you get a sequence name in a format suitable for use with the sequence
functions.

Has docs and regression.

I updated pg_dump to use it as well.

Tested against 7.5 and 7.4 backends, with independent and dependent
sequences. Handles quoting, escaping and schema-qualification.

Someone might want to run their eyes over my doc changes (I have no way
of compiling them) and check that my function is done in the most
efficient way. (It's small!)

Chris

Attachments:

pg_get_serial_sequence.txt.gzapplication/x-gzip; name=pg_get_serial_sequence.txt.gzDownload
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christopher Kings-Lynne (#1)
Re: pg_get_serial_sequence

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:

Attached is a new backend function, pg_get_serial_sequence.

Applied with some editorialization...

regards, tom lane