Sender: root@macadamia.itd.uts.edu.au
Message-ID: <380D30BA.111ED2CC@uts.edu.au>
Date: Wed, 20 Oct 1999 03:02:18 +0000
From: Jim Lemon <jim.lemon@uts.EDU.AU>
Organization: Health Psychology
MIME-Version: 1.0
To: pgsql-interfaces@hub.org
Subject: PgAccess unable to start
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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