Re: PGACCESS connection failure?

Wasn't that thing with the OID fixed?

Preston,

Which pgaccess version do you run? If it is 0.98.7 - you can get 0.98.8
(release 1) form www.pgaccess.org - there the OID error should have been
fixed. This is a development, but very stable version. pgaccess 0.98.8
is planned to be released together with PostgreSQL 7.3

Which PostreSQL version do you use?

Iavor

> -----Original Message-----
> From: pgsql-interfaces-owner(at)postgresql(dot)org
> [mailto:pgsql-interfaces-owner(at)postgresql(dot)org]On Behalf Of
> Preston Lord
> Sent: Dienstag, 30. Juli 2002 01:27
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: Re: [INTERFACES] PGACCESS connection failure?
>
>
> cool, that will work!
>
> Now, another Question..,. I have got pgaccess to run
> but everytime I try to click "Design" on one of my tables I
> get an error
> that says:
>
> Note: (oid exists, I can see it fine in all other gui's etc) ideas?
>
> ERROR: Attribute 'oid' not found
>
> ERROR: Attribute 'oid' not found
>
> while executing
> "pg_select pgsql4 {select oid,indexrelid from pg_index where
> (pg_class.relname='ebads') and (pg_class.oid=pg_index.indrelid)} rec {
> lappend PgAcVar(t..."
> ("uplevel" body line 1)
> invoked from within
> "uplevel pg_select $args"
> (procedure "wpg_select" line 3)
> invoked from within
> "wpg_select $CurrentDB "select oid,indexrelid from pg_index where
> (pg_class.relname='$PgAcVar(tblinfo,tablename)') and
> (pg_class.oid=pg_index.indrelid)..."
> (procedure "refreshTableInformation" line 48)
> invoked from within
> "refreshTableInformation"
> (procedure "Tables::design" line 5)
> invoked from within
> "Tables::design $objname"
> ("Tables" arm line 2)
> invoked from within
> "switch $PgAcVar(activetab) {
> Tables {
> Tables::design $objname
> }
> Schema {
> Schema::open $objname
> }
> Queries {
> Queries::design $objname
> }
> V..."
> (procedure "Mainlib::cmd_Design" line 7)
> invoked from within
> "Mainlib::cmd_Design"
> invoked from within
> ".pgaw:Main.btndesign invoke"
> ("uplevel" body line 1)
> invoked from within
> "uplevel #0 [list $w invoke]"
> (procedure "tkButtonUp" line 7)
> invoked from within
> "tkButtonUp .pgaw:Main.btndesign
> "
> (command bound to event)
>
>
> On Mon, 2002-07-29 at 17:12, William West wrote:
> >
> > Easiest way to make '-i' automatic is to put it into
> > $PGDATA/postmaster.opts.default.
> >
> > That file does not automatically exist ... but if you create it,
> > postmaster will use it every time it starts.
> >
> > You can also put it on postmaster's command line,
> > or pass it in from pg_ctl's command line, depending
> > on how you start the server.