Re: Show sequences owned by

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Show sequences owned by
Дата
Msg-id 20111104142936.GH24234@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Show sequences owned by  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Show sequences owned by  (Magnus Hagander <magnus@hagander.net>)
Re: Show sequences owned by  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
* Magnus Hagander (magnus@hagander.net) wrote:
> If there is noone owning it at all, it just falls through the if/else
> block and ignores it if that happens (PQntuples() returns 0).

Ah, right, but 'result' is still non-zero, ok.

> Is there really a case for multiple sequences to own it? How would you
> go about making that happen? ALTER SEQUENCE.. OWNED BY.. only takes
> one table, afaics?

I just noticed it was pulling from pg_depend and we could be creating
multiple dependencies on a single sequence by having two tables use it
as a default value.  If that situation doesn't cause a problem for this,
then that's fine. :)  Couldn't remember if we distinguished 'owned by'
from 'dependend upon' for seqeunces.
Thanks,
    Stephen

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: removing =>(text, text) in 9.2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: IDLE in transaction introspection