pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

PgAccess unable to start
3+ messages / 2 participants
[nested] [flat]

* PgAccess unable to start
@ 1999-10-20 03:02  Jim Lemon <jim.lemon@uts.EDU.AU>
  0 siblings, 1 reply; 3+ messages in thread

From: Jim Lemon @ 1999-10-20 03:02 UTC (permalink / raw)
  To: pgsql-interfaces@hub.org

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [INTERFACES] PgAccess unable to start
@ 1999-10-20 06:13  Constantin Teodorescu <teo@flex.ro>
  parent: Jim Lemon <jim.lemon@uts.EDU.AU>
  0 siblings, 0 replies; 3+ messages in thread

From: Constantin Teodorescu @ 1999-10-20 06:13 UTC (permalink / raw)
  To: Jim Lemon <jim.lemon@uts.EDU.AU>; pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [INTERFACES] PgAccess unable to start
@ 1999-10-24 22:14  Jim Lemon <jim.lemon@uts.EDU.AU>
  0 siblings, 0 replies; 3+ messages in thread

From: Jim Lemon @ 1999-10-24 22:14 UTC (permalink / raw)
  To: pgsql-interfaces

Constantin Teodorescu wrote:

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

I checked in /usr/local/pgsql/lib and all of the timestamps are the same
(Oct 6 12:58).  Wouldn't this also affect psql?

Jim



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~1999-10-24 22:14 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-20 03:02 PgAccess unable to start Jim Lemon <jim.lemon@uts.EDU.AU>
1999-10-20 06:13 ` Constantin Teodorescu <teo@flex.ro>
1999-10-24 22:14 Re: [INTERFACES] PgAccess unable to start Jim Lemon <jim.lemon@uts.EDU.AU>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox