pg_get_serial_sequence and table inheritence

[Timothy Perrigo <tperrigo@xxxxxxxxxxxxx>]

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