Re: psql 8.2 client vs pg 8.1 server problem - Mailing list pgsql-general

From Dave Page
Subject Re: psql 8.2 client vs pg 8.1 server problem
Date
Msg-id 46AF2BEE.1020502@postgresql.org
Whole thread Raw
In response to psql 8.2 client vs pg 8.1 server problem  (Alban Hertroys <alban@magproductions.nl>)
Responses Re: psql 8.2 client vs pg 8.1 server problem  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
Alban Hertroys wrote:
> We have psql 8.2 clients on our workstations, while we still have pg 8.1
> on our development and production servers. This causes problems like the
> following:
>
> database> \d table
> ERROR:  column i.indisvalid does not exist
> database>
>
> We can log into the server and use the local client of course, but this
> problem is causing some confusion among our new employees and doesn't
> exactly inspire them with the reliability we know PostgreSQL has...
>
> Is there a better workaround, or may this be a bug even?

Install the 8.1 version of psql on your workstations (and symlink it to
psql81 or something if necessary). psql doesn't make any promises about
backward compatibility - for that, you'll need to use something like
pgAdmin (even that may need to be pointed at the older versions of
pg_dump etc if you're going to run backups from the workstations).

Regards, Dave.

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: psql 8.2 client vs pg 8.1 server problem
Next
From: Alvaro Herrera
Date:
Subject: Re: Core reported from vaccum function.