Thread: BUG #6694: 9.2 beta 2 : psql commands \db and \db+ fail
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:=20=20=20=20=20=20=20=20
Using the latest 9.2 beta 2 version, I got an error when issuing \db or \db+
psql command.
paf=3D# select version();
version=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20=20=20
=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20
---------------------------------------------------------------------------=
-------------------------------
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=3D# \db
ERROR: column "spclocation" does not exist
LINE 3: spclocation AS "Location"
^
paf=3D# \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.
Regards. Philippe.
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
On Thu, Jun 14, 2012 at 1:34 PM, Ryan Kelly <rpkelly22@gmail.com> wrote:
> On Wed, Jun 13, 2012 at 07:17:11PM +0000, phb.emaj@free.fr wrote:
>> paf=3D# \db
>>
>> ERROR: =A0column "spclocation" does not exist
>>
>> LINE 3: =A0 spclocation AS "Location"
>>
>> =A0 =A0 =A0 =A0 =A0 ^
>>
> 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.
Yeah, the OP must be using a 9.1 or earlier psql to connect to the
9.2beta2 server showed in his version() output. There's a reason we
print out a warning like this:
WARNING: psql version X.a, server version Y.b
Some psql features might not work.
when the major version of psql and the server it is connecting to don't mat=
ch.
Josh
Hello, >>> paf=# \db >>> >>> ERROR: column "spclocation" does not exist >>> >>> LINE 3: spclocation AS "Location" >>> >>> ^ >>> >>> > > >> 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. >> > > Yeah, the OP must be using a 9.1 or earlier psql to connect to the > 9.2beta2 server showed in his version() output. There's a reason we > print out a warning like this: > > WARNING: psql version X.a, server version Y.b > Some psql features might not work. > > when the major version of psql and the server it is connecting to don't match. > > Josh > > Oups ! You are right, I was not using the right psql client version!!! I am using different pg version for various tests. And I failed here to use the right PATH. Please accept my apologies for the noise. I will be more careful before reporting the next bug ;-) Best regards. Philippe.