Re: Inverse of pg_get_serial_sequence?

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Inverse of pg_get_serial_sequence?
Дата
Msg-id CA+Tgmob6XVWPZ-GWs_5vEov5LVq5whtbS-MRHc5ZodoFq8QDQQ@mail.gmail.com
обсуждение исходный текст
Ответ на Inverse of pg_get_serial_sequence?  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: Inverse of pg_get_serial_sequence?  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
On Fri, Aug 29, 2014 at 1:26 PM, Andres Freund <andres@2ndquadrant.com> wrote:
> 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'll go out on a limb and say that it sounds like pointless catalog
bloat to me.  I am all in favor of adding things like this where the
SQL query is painful to write (e.g. things involving pg_depend) but if
it's a simple SELECT query then, eh, not really excited about it.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Joel Jacobson
Дата:
Сообщение: Re: PL/pgSQL 2
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Misleading error message in logical decoding for binary plugins