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

Re: BUG #6694: 9.2 beta 2 : psql commands \db and \db+ fail

From: Ryan Kelly <rpkelly22(at)gmail(dot)com>
To: phb(dot)emaj(at)free(dot)fr
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6694: 9.2 beta 2 : psql commands \db and \db+ fail
Date: 2012-06-14 20:34:20
Message-ID: 20120614203420.GC319@llserver.lakeliving.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, Jun 13, 2012 at 07:17:11PM +0000, phb(dot)emaj(at)free(dot)fr wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      6694
> Logged by:          Philippe Beaudoin
> Email address:      phb(dot)emaj(at)free(dot)fr
> PostgreSQL version: Unsupported/Unknown
> Operating system:   linux
> Description:        
> 
> Using the latest 9.2 beta 2 version, I got an error when issuing \db or \db+
> psql command.
> 
> paf=# select version();
> 
>                                                  version                    
>                              
> 
> ----------------------------------------------------------------------------------------------------------
> 
>  PostgreSQL 9.2beta2 on i686-pc-linux-gnu, compiled by gcc (GCC) 4.4.0
> 20090506 (Red Hat 4.4.0-4), 32-bit
> 
> (1 row)
> 
> 
> 
> paf=# \db
> 
> ERROR:  column "spclocation" does not exist
> 
> LINE 3:   spclocation AS "Location"
> 
>           ^
> 
> paf=# \db+
> 
> ERROR:  column "spclocation" does not exist
> 
> LINE 3:   spclocation AS "Location",
> 
>           ^
> I presume this is linked to the "Remove the spclocation field from
> pg_tablespace" item of the release notes
> and that something like the new pg_tablespace_location() function should be
> used by psql.
Are you using the psql provided by 9.2 beta 2? Or an older version? It
appears that the version of psql in 9.2 beta 2 does the correct thing,
look at src/bin/psql/describe.c line 142 or so.

> 
> Regards. Philippe.
> 
> 
> -- 
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

-Ryan Kelly

In response to

Responses

pgsql-bugs by date

Next:From: fabio.lunkesDate: 2012-06-15 00:17:36
Subject: BUG #6695: PgAdminIII
Previous:From: Amit KapilaDate: 2012-06-14 05:24:18
Subject: Re: 9.2 beta2 - pg_ctl crashes on Win32 when neither PGDATA nor -D specified

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