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@postgresql.org
> [mailto:pgsql-interfaces-owner@postgresql.org]On Behalf Of
> Preston Lord
> Sent: Dienstag, 30. Juli 2002 01:27
> To: pgsql-interfaces@postgresql.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.