Re: Show sequences owned by - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Show sequences owned by
Date
Msg-id CABUevEzMckUZPZf3KJwGQSob2t_bPb6q2YqGun62mCXzVcg_Yw@mail.gmail.com
Whole thread Raw
In response to Re: Show sequences owned by  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Show sequences owned by
List 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/

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: heap_page_prune comments
Next
From: Magnus Hagander
Date:
Subject: Re: Show statistics target in \d+