Received: from helix.t2.net (www.t2.net [216.174.158.101])
	by postgresql.org (Postfix) with ESMTP id 06C5047594A
	for <pgsql-interfaces@postgresql.org>;
	Mon, 29 Jul 2002 19:25:17 -0400 (EDT)
Received: from preston.doublet ([142.165.199.111])
	by helix.t2.net (Merak 4.4.1) with ESMTP id JJF36659
	for <pgsql-interfaces@postgresql.org>; Mon, 29 Jul 2002 17:23:23 -0600
Subject: Re: PGACCESS connection failure?
From: Preston Lord <webmaster@t2.net>
To: pgsql-interfaces@postgresql.org
In-Reply-To: <OF8B3ED434.8636FB36-ON85256C05.007F1349@com>
References: <OF8B3ED434.8636FB36-ON85256C05.007F1349@com>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 29 Jul 2002 17:26:55 -0600
Message-Id: <1027985215.1202.5.camel@preston>
Mime-Version: 1.0
X-Archive-Number: 200207/138
X-Sequence-Number: 2947

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.
> 
-- 

Regards

Preston Lord
Programmer/Developer
Network Specialist
_______________
General Manager
Double T Computer Services
Sask, Canada
1.306.773.2054
http://www.t2.net