Skip site navigation (1) Skip section navigation (2)

Re: BUG #6694: 9.2 beta 2 : psql commands \db and \db+ fail

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 (view raw or flat)
Thread:
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

In response to

Responses

pgsql-bugs by date

Next:From: Sachin SrivastavaDate: 2012-06-15 05:43:50
Subject: Re: BUG #6691: Unable to install PostgrSQL
Previous:From: fabio.lunkesDate: 2012-06-15 00:17:36
Subject: BUG #6695: PgAdminIII

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group