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

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