Bug in psql/enum

Lists: pgsql-hackers
From: David Fetter <david(at)fetter(dot)org>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Bug in psql/enum
Date: 2008-01-21 03:03:33
Message-ID: 20080121030333.GE20552@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Folks,

8.3's psql is ponderously unhelpful when getting the type description
of an enum, so I'd like to propose a new column in the \dT output
which can contain those values in an array format. Yes, I know it
looks like a new feature, but it's really a bug fix.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in psql/enum
Date: 2008-01-21 03:55:11
Message-ID: 20315.1200887711@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

David Fetter <david(at)fetter(dot)org> writes:
> 8.3's psql is ponderously unhelpful when getting the type description
> of an enum, so I'd like to propose a new column in the \dT output
> which can contain those values in an array format.

... and how wide is your screen, again?

regards, tom lane


From: David Fetter <david(at)fetter(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in psql/enum
Date: 2008-01-21 10:38:40
Message-ID: 20080121103840.GJ20552@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Sun, Jan 20, 2008 at 10:55:11PM -0500, Tom Lane wrote:
> David Fetter <david(at)fetter(dot)org> writes:
> > 8.3's psql is ponderously unhelpful when getting the type
> > description of an enum, so I'd like to propose a new column in the
> > \dT output which can contain those values in an array format.
>
> ... and how wide is your screen, again?

Excellent point. How about stacking them together one per line? I
guess this would need to be one thing for Windows and another for
Everybody Else. How about putting it in the \dT+ output?

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


From: Bruce Momjian <bruce(at)momjian(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in psql/enum
Date: 2008-03-25 02:33:45
Message-ID: 200803250233.m2P2XjX29023@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


Added to psql TODO:

o Improve display if enums

http://archives.postgresql.org/pgsql-hackers/2008-01/msg00826.php

---------------------------------------------------------------------------

David Fetter wrote:
> Folks,
>
> 8.3's psql is ponderously unhelpful when getting the type description
> of an enum, so I'd like to propose a new column in the \dT output
> which can contain those values in an array format. Yes, I know it
> looks like a new feature, but it's really a bug fix.
>
> Cheers,
> David.
> --
> David Fetter <david(at)fetter(dot)org> http://fetter.org/
> Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
> Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +