Skip site navigation (1) Skip section navigation (2)

Re: PGACCESS connection failure?

From: "Iavor Raytchev" <iavor(dot)raytchev(at)verysmall(dot)org>
To: "pgaccess - developers" <developers(at)pgaccess(dot)org>
Cc: "Preston Lord" <webmaster(at)t2(dot)net>,"pgsql-interfaces" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: PGACCESS connection failure?
Date: 2002-07-29 23:39:55
Message-ID: HKEIIDPFPDBMOMDLIEEGMEMNCKAA.iavor.raytchev@verysmall.org (view raw or flat)
Thread:
Lists: pgsql-interfaces
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.


In response to

pgsql-interfaces by date

Next:From: C. MajDate: 2002-07-30 02:14:23
Subject: Re: PGACCESS connection failure?
Previous:From: Jim ParkerDate: 2002-07-29 23:37:03
Subject: Re: ECPG and dynamic SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group