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
in
2005/5/31, Timothy Perrigo <[EMAIL PROTECTED]>:
> 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 f
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 (
idserial not null primary key
);
and
create table derived (
stufftext,
constraint derived_pkey primary key(id)
)
