Re: Quick patch: Display sequence owner

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Quick patch: Display sequence owner
Дата
Msg-id 14270.1228833139@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Quick patch: Display sequence owner  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Quick patch: Display sequence owner  (Josh Williams <joshwilliams@ij.net>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Josh Williams wrote:
>> The patch adds a query against pg_depend, then fakes an extra column
>> "owned_by" in the output:

> Please send a context diff (diff -c)

Don't bother --- it's a really bad idea as designed anyway.  owned_by
is not a column of a sequence relation and pretending that it is one
will just cause confusion.

I think the place that such information could most naturally be squeezed
into psql's \d commands would be to add another type of footer
information to \dt, eg
    Table "foo.bar"...Indexes:    "bari" ...Owned sequences:    "baz" owned by col1    ...

If you really want to attach the information to the \d output for the
sequence instead of the table, consider a similar footer-style display
instead of making it look like something it's not.
        regards, tom lane


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Multiplexing SUGUSR1
Следующее
От: Andrew Chernow
Дата:
Сообщение: Re: new libpq SSL connection option