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

On Wed, Jun 13, 2012 at 07:17:11PM +0000, phb.emaj@free.fr wrote:
> The following bug has been logged on the website:
>
> Bug reference:      6694
> Logged by:          Philippe Beaudoin
> Email address:      phb.emaj@free.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

-Ryan Kelly