Re: 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(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.

Regards. Philippe.

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

On Thu, Jun 14, 2012 at 1:34 PM, Ryan Kelly <rpkelly22(at)gmail(dot)com> wrote:
> On Wed, Jun 13, 2012 at 07:17:11PM +0000, phb(dot)emaj(at)free(dot)fr wrote:

>> 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

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.