Re: Show sequences owned by

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: Show sequences owned by
Дата
Msg-id CABUevEzMckUZPZf3KJwGQSob2t_bPb6q2YqGun62mCXzVcg_Yw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Show sequences owned by  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Show sequences owned by  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, Nov 4, 2011 at 15:44, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Stephen Frost <sfrost@snowman.net> writes:
>> 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.
>
> Yeah, we do, via the deptype.  The check for deptype = 'a' is the
> correct thing here.
>
> Still, I'm not terribly comfortable with having multiple matches be
> treated as a reason to fail the entire \d command.  It'd likely be
> better to just not add a footer if you get an unexpected number of
> matches.

Ok.

Updated patch attached that does this, and the proper schema qualifications.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Вложения

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

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