Re: Back End Version-aware psql

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