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

Re: Back End Version-aware psql

From: "Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)jp>
To: "David Fetter" <david(at)fetter(dot)org>
Cc: <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Back End Version-aware psql
Date: 2003-08-01 00:23:38
Message-ID: 013d01c357c3$274490b0$1f324d80@w2k (view raw or flat)
Thread:
Lists: pgadmin-hackers
Dear David Fetter.

Version 7.2 is doesn't know schema.
Version 7.3 uses schema syntax in its internal queries.
Therefore the thing which can handle schema is necessary in more than 7.3.

But, it can talk with both with pgAdminII.
It is wonderful.

If it is wished to psql itself.
Please,
[pgsql-hackers] is good when it wants to clear these more.

Regards,
Hiroshi-Saito

----- Original Message ----- 
From: "David Fetter" <david(at)fetter(dot)org>
To: "PG Hackers" <pgadmin-hackers(at)postgresql(dot)org>
Sent: Friday, August 01, 2003 5:37 AM
Subject: [pgadmin-hackers] Back End Version-aware psql


> Kind people,
> 
> I've been digging through the CVS code and trying to figure out the
> best approach to making one psql that "does the right thing" for
> different versions of the back-end.  This has come up in a real
> situation already, where the dev box is 7.3.3 and the production box
> is (Yikes!) 7.2.1.  Connecting from the 7.3.3 side results in a lot of
> stuff like this:
> 
> Password: 
> ERROR:  parser: parse error at or near "."
> Welcome to psql 7.3.3, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help on internal slash commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> template1=> \dt
> ERROR:  parser: parse error at or near "."
> template1=> 
> 
> Luckily, it works (so far) ok going from 7.2.1 -> 7.3.3, though.
> 
> So which files need consideration to make this reasonably seamless?
> Are they all in src/bin/psql, or are there others elsewhere that
> should know?
> 
> TIA :)
> 
> Cheers,
> D
> -- 
> David Fetter david(at)fetter(dot)org http://fetter.org/
> phone: +1 510 893 6100    cell: +1 415 235 3778

In response to

pgadmin-hackers by date

Next:From: Andreas PflugDate: 2003-08-01 01:13:02
Subject: Re: dlgIndex comment is missing.
Previous:From: Hiroshi SaitoDate: 2003-07-31 22:28:28
Subject: dlgIndex comment is missing.

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