| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Show sequences owned by |
| Date: | 2011-11-04 14:09:03 |
| Message-ID: | 20111104140903.GF24234@tamriel.snowman.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Magnus,
* Magnus Hagander (magnus(at)hagander(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2011-11-04 14:09:08 | Re: Show statistics target in \d+ |
| Previous Message | Robert Haas | 2011-11-04 14:06:07 | Re: Show statistics target in \d+ |