Lists: | pgsql-bugs |
---|
From: | phb(dot)emaj(at)free(dot)fr |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6694: 9.2 beta 2 : psql commands \db and \db+ fail |
Date: | 2012-06-13 19:17:11 |
Message-ID: | E1Set43-0001xm-7A@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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.
From: | Ryan Kelly <rpkelly22(at)gmail(dot)com> |
---|---|
To: | phb(dot)emaj(at)free(dot)fr |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6694: 9.2 beta 2 : psql commands \db and \db+ fail |
Date: | 2012-06-14 20:34:20 |
Message-ID: | 20120614203420.GC319@llserver.lakeliving.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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
From: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
---|---|
To: | Ryan Kelly <rpkelly22(at)gmail(dot)com> |
Cc: | phb(dot)emaj(at)free(dot)fr, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6694: 9.2 beta 2 : psql commands \db and \db+ fail |
Date: | 2012-06-15 00:36:42 |
Message-ID: | CAK3UJRE17Zsc_H+y-vAuiZ+qZef5+nRwVJmDCFbDGt20T8vu-w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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
From: | Philippe BEAUDOIN <phb(dot)emaj(at)free(dot)fr> |
---|---|
To: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
Cc: | Ryan Kelly <rpkelly22(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6694: 9.2 beta 2 : psql commands \db and \db+ fail |
Date: | 2012-06-15 12:50:29 |
Message-ID: | 4FDB2F95.9060800@free.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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.