Re: Show sequences owned by
Stephen Frost <sfrost@snowman.net>
From: Stephen Frost <sfrost@snowman.net>
To: Magnus Hagander <magnus@hagander.net>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-11-04T14:09:03Z
Lists: 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