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: (view raw, whole thread or download thread mbox)
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.


In response to


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-2017 The PostgreSQL Global Development Group