Re: Show sequences owned by

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Show sequences owned by
Дата
Msg-id 20111104140903.GF24234@tamriel.snowman.net
обсуждение исходный текст
Ответ на Show sequences owned by  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Show sequences owned by  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
Magnus,

* Magnus Hagander (magnus@hagander.net) wrote:
> The attached patch makes the \d output for psql on a sequence show
> which table/column owns the sequence. The table already showed the
> dependency the other way through the default value, but going from
> sequence back to table was not possible.

Seems reasonable.

> Comments/reviews?

Not sure if that 'goto error_return;' handles this correctly, but it
would seem like you're missing the possibility that a sequence isn't
owned by any table/column..?  Or that it could be depended upon by more
than one table/column?  Both of those happen and are perfectly valid
situations for a sequence to be in..
Thanks,
    Stephen

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Show statistics target in \d+
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Show statistics target in \d+