Inverse of pg_get_serial_sequence?

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Inverse of pg_get_serial_sequence?
Дата
Msg-id 20140829172637.GG10109@awork2.anarazel.de
обсуждение исходный текст
Ответы Re: Inverse of pg_get_serial_sequence?  (David G Johnston <david.g.johnston@gmail.com>)
Re: Inverse of pg_get_serial_sequence?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hi,

We have pg_get_serial_sequence() mapping (relation, colum) to the
sequence. What I'm missing right now is the inverse. I.e. given a
sequence tell me the owner.
describe.c has a query for that, and it's not too hard to write, but it
still seems 'unfriendly' not to provide it.

Does anybody dislike adding a function for that?


I can't really think of a good name (not that pg_get_serial_sequence is
well named). pg_get_serial_sequence_owner(serial regclass, OUT rel
regclass, OUT colname name) maybe?

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: On partitioning
Следующее
От: Tom Lane
Дата:
Сообщение: Re: On partitioning