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

Re: BUG #2177: (minor:) pgsql: Trailing semicolon on \d treated

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Giles Morant <giles(dot)pg(at)chaletpomme(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2177: (minor:) pgsql: Trailing semicolon on \d treated
Date: 2006-01-19 21:55:26
Message-ID: 200601192155.k0JLtQn29121@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
We can't just throw away semicolons, e.g.:

	\test=> \f ;
	Field separator is ";".

The current behavior seems pretty good.  It doesn't seem worth
improving.

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

Giles Morant wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      2177
> Logged by:          Giles Morant
> Email address:      giles(dot)pg(at)chaletpomme(dot)com
> PostgreSQL version: 8.1.1
> Operating system:   Linux (Gentoo)
> Description:        (minor:) pgsql: Trailing semicolon on \d treated as
> argument
> Details: 
> 
> When describing tables/view/indexes using \d, a semi-colon is optional:
> e.g.  \d users;
> or:   \d users
> Both give the same (correct) results.
> 
> However, if there is a space between "users" and the semi-colon, the
> semi-colon is then treated as an argument and this occurs:
>    \d users ;
>    <cut lots of table info>
>    \d: extra argument ";" ignored
> 
> The semi-colon should be ignored silently, in my view- "SELECT 1+2 ;" for
> example doesn't raise an alert.
> 
> I searched the mailing lists to find a previous report of this very minor
> bug; the closest I found was some discussion in 2001 of stripping
> semi-colons from the end of such strings but the discussion seemed to stop
> with no resolution.
> 
> http://archives.postgresql.org/pgsql-patches/2001-09/msg00285.php
> Fri, 28 Sep 2001 15:56:07 -0400 (EDT)
> 
> Thanks,
> Giles Morant.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 

-- 
  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

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2006-01-19 21:59:24
Subject: Re: BUG #2000: psql does not prompt for password
Previous:From: Michael FuhrDate: 2006-01-19 21:40:42
Subject: Re: BUG #2178: NOT IN command don't work

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