| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | pg_get_serial_sequence |
| Date: | 2004-06-21 05:39:54 |
| Message-ID: | 40D674AA.9060302@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
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
| Attachment | Content-Type | Size |
|---|---|---|
| pg_get_serial_sequence.txt.gz | application/x-gzip | 4.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2004-06-21 06:55:32 | Show encoding in initdb messages |
| Previous Message | Gavin Sherry | 2004-06-21 05:13:39 | Re: [PATCHES] ALTER TABLE ... SET TABLESPACE |