Thread: PgAccess unable to start

After upgrading to postgresql 6.5.2 and pgaccess 0.98, I have been
unable to start pgaccess, although I can use psql okay.  When starting
pgaccess, the error message:

Tcl error executing pg_exec
select relname from pg_class
where relname='pga_queries'

Invalid optionpg_result result
?option ? where ?option is-status-conn-assign
arrayVarName-assignbyidx
arrayVarName-numTuples-attributes-lAttributes-numAttrs-getTuple
tupleNumber-tupleArray
tupleNumber arrayVarName-clear-oid

appears and PgAccess exits.  On the basis that this might have been due
to the databases hanging around from the old postgresql setup, I
destroyed them all and ran 'createdb' so that there would be a database
to which PgAccess could connect on startup.  However, no luck.  Should I
try to trash and reinstall both PostgreSQL and PgAccess?  Thanks.

Jim

Jim Lemon wrote:
> 
> After upgrading to postgresql 6.5.2 and pgaccess 0.98, I have been
> unable to start pgaccess, although I can use psql okay.  When starting
> pgaccess, the error message:
> 
> Tcl error executing pg_exec
> select relname from pg_class
> where relname='pga_queries'

First of all, did you delete also all traces of old postgresql
libraries?

It sounds like a mix of old  and new libraries.

Teo