SEO

#1 (**permalink**) 04-08-2008, 09:12 PM

Is there anything similar to pg_get_serial_sequence that will work
with tables that have an inherited serial column? For example, if I
have 2 tables:

create table base (
id serial not null primary key
);

and

create table derived (
stuff text,
constraint derived_pkey primary key(id)
) inherits (base);

I'd like to be able to call pg_get_serial_sequence passing "derived"
for the table and "id" for the sequence column (to get, in this case
"base_id_seq"). If nothing like this currently exists, any
suggestions on how I could write a plpgsql function to get this
behavior?

Thank you for any suggestions!
Tim

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

#2 (**permalink**) 04-08-2008, 09:12 PM

2005/5/31, Timothy Perrigo <tperrigo@wernervas.com>:

> I'd like to be able to call pg_get_serial_sequence passing "derived"
> for the table and "id" for the sequence column (to get, in this case
> "base_id_seq"). If nothing like this currently exists, any
> suggestions on how I could write a plpgsql function to get this
> behavior?

You have one sequence for every serial field in sequences (from psql: "\ds").

--
Rafa Couto (caligari)
mailto:rafacouto@gmail.com

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#3 (**permalink**) 04-09-2008, 05:10 AM

Timothy Perrigo wrote:

> Is there anything similar to pg_get_serial_sequence that will work with
> tables that have an inherited serial column? (...)

Sorry, I should have searched before posting, I started a new thread.
Please refer to my solution posted today as "pg_get_serial_sequence and
inheritence" (remarkably similar to yours! although mine was less
accurate ;-)

Cheers,

Ezequiel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

pg_get_serial_sequence and table inheritence