pg_get_serial_sequence and table inheritence

Поиск
Список
Период
Сортировка
От Timothy Perrigo
Тема pg_get_serial_sequence and table inheritence
Дата
Msg-id 1459CCC1-5847-4E3B-82CC-11D4B94698F1@wernervas.com
обсуждение исходный текст
Ответы Re: pg_get_serial_sequence and table inheritence  (Rafa Couto <rafacouto@gmail.com>)
Re: pg_get_serial_sequence and table inheritence  (Ezequiel Tolnay <mail@etolnay.com.ar>)
Список pgsql-general
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



В списке pgsql-general по дате отправления:

Предыдущее
От: "Zlatko Matic"
Дата:
Сообщение: Re: How to add an INHERITS to an already populated table ?
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: How to add an INHERITS to an already populated table