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