Re: Quick patch: Display sequence owner - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Quick patch: Display sequence owner
Date
Msg-id 3073cc9b0812091136s59282678k150510bb71b05c4e@mail.gmail.com
Whole thread Raw
In response to Re: Quick patch: Display sequence owner  (Josh Williams <joshwilliams@ij.net>)
List pgsql-hackers
On Tue, Dec 9, 2008 at 10:46 AM, Josh Williams <joshwilliams@ij.net> 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?
>

actually, when a try your patch i have to look at the code to find
where you put such information... i tried \dt first...

> Doesn't guarantee the sequence is owned by the table of course, but I'd
> imagine to most people it'd just be noise.  Could see it being shown in
> the verbose version, \d+ foo.bar.
>

that's exactly why we want the aditional info... the idea of putting
it on \d+ doesn't sounds too bad... to me at least...

> For the sequences themselves, it'd be nice to show somewhere, at least
> for tracking down stray sequences and identifying relationships.

in \ds maybe

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: parallel restore vs. windows
Next
From: Magnus Hagander
Date:
Subject: Re: SSL BIO wrappers