Re: [INTERFACES] Can;t connect to db with pgaccess

Constantin Teodorescu <teo@flex.ro> writes:
> Stan Brown wrote:
>> Downloaded the latest pgacess. Looks pretty neat. Unfortunatley it will
>> not connect to my 6.3 database.

> PgAccess 0.93 will work fine on PostgreSQL 6.4 and higher.
> Due to some enhancements made in libpgtcl, there is another option to
> pg_result (-error) that does not exist in PosgreSQL 6.3.x

I think Stan's problem is at a lower level than that: 6.4 libpq will not
talk to a pre-6.4 server, period.  (It wants the 2.0 version of the
FE-to-BE protocol, which the older servers don't offer.  The other way
around, new server and old client, is no problem.)

6.4 libpgtcl won't work without 6.4 libpq, either.

You could put the PgAccess 0.93 Tcl code atop a 6.3.x libpgtcl and
libpq, and then it'd talk to older servers.  I dunno whether the
"-error" change that Constantin mentions is the only change that
would be needed in the Tcl code.

It'd probably be a more profitable use of your time to upgrade to
a 6.4(.1) server.  My experience is that 6.4 is a good deal more
stable than 6.3.x...

            regards, tom lane