Skip site navigation (1) Skip section navigation (2)

Re: show casts and conversions in psql (2nd try)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: show casts and conversions in psql (2nd try)
Date: 2002-12-11 03:47:04
Message-ID: 200212110347.gBB3l4Y19778@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Your patch has been added to the PostgreSQL unapplied patches list at:

	http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

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


Christopher Kings-Lynne wrote:
> (Doh!  Forgot to attach first time.)
> 
> This partially nails this TODO item:
> 
> * Add schema, cast, and conversion backslash commands to psql
> 
> I had to create a new publically available function,
> pg_conversion_is_visible, as it seemed to be missing from the catalogs.
> This required me to do no small amount of hacking around in namespace.c
> 
> I have updated the \? help and sgml docs.
> 
> \dc - list conversions [PATTERN]
> \dC - list casts
> 
> I didn't support patterns with casts as there's nothing obvious to match
> against.
> 
> I've tested it a fair bit and I can't see any problems.  Feel free to do a
> once over on my backend changes tho.
> 
> Chris

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-12-11 03:49:12
Subject: Re: Patch for DBD::Pg pg_relcheck problem
Previous:From: Bruce MomjianDate: 2002-12-11 03:37:12
Subject: Re: [HACKERS] GEQO Triggers Server Crash

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2002-12-11 03:50:19
Subject: shows casts, conversions and schemas in psql #2
Previous:From: Bruce MomjianDate: 2002-12-11 03:46:53
Subject: Re: ALTER DOMAIN .. OWNER TO ..

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group