Обсуждение: 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.