Re: Quick patch: Display sequence owner

Josh Williams wrote:
> On Tue, 2008-12-09 at 09:32 -0500, Tom Lane wrote:
> > 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
> 
> That makes more sense, though isn't that a little repetitive when
> "default nextval(...)" is visible immediately above it?

I don't think that it is all that repetitive.  It's not uncommon to see
people creating sequences and assigning to default values, without
setting the OWNED BY bits.  It's good that this information is very
visible.  It's only a couple more lines in the common case anyway (if
you want to save half of that overhead, make it a single line when
there's a single sequence.)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support