agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Tom Wye <tjw00@spg.amdahl.com>
To: postgres@postgres.Berkeley.EDU
Subject: Question about a pgbrowse error i am getting with postgres 4.2
Date: Mon, 25 Apr 94 14:48:48 PDT
Message-ID: <9404252148.AA00629@petal.spg.amdahl.com> (raw)
Hi
I am a new user of PGBROWSE and POSTGRES. I am getting an error from PGBROWSE whenever I
attempt to update a instance or add a instance to a class.
The error is a parsing error see below, on statement where sic.oid = "161504::oid".
Looks like the ::field name gets appended when it should not.
Does PGBROWSE 3.1b work ok with version 4.2 of postgres? Anyone else getting this error?
Please response by email tjw00@spg.amdahl.com
Thanks.
--------------------------------------------------------------------------------------------
my environment is:
SUN OS 4.1.3
postgres 4.2
PGBROWSE 3.1b
TCL 3.6
TK 3.6
TCLX 7.3a-patch.level2
--------------------------------------------------------------------------------------------
Here's the PGBROWSE-v3.1b error I get on the UNIX console
WARN:Apr 25 14:13:56:pg_atoi: error in "161504::oid": can't parse "::oid"
--------------------------------------------------------------------------------------------
Here's the PGBROWSE log
Postquel
retrieve (
pg_attribute.attname, pg_attribute.attnum,
pg_type.typname, pg_attribute.attnelems,
metadata=pgb_get_meta("sic"::char16,pg_attribute.attname)
)
where pg_attribute.attrelid = pg_class.oid
and pg_attribute.atttypid = pg_type.oid
and pg_attribute.attnum > 0
and pg_class.relname = "sic"
Success
Pblank - 5 columns, 2 lines
Postquel
retrieve (pg_operator.oprname)
WHERE PG_operator.oprleft = pg_type.oid
and pg_type.typname = "text"
Success
Pblank - 1 columns, 8 lines
Postquel
retrieve (pg_operator.oprname)
where pg_operator.oprleft = pg_type.oid
and pg_type.typname = "int2"
Success
Pblank - 1 columns, 22 lines
Postquel
retrieve (pg_operator.oprname)
where pg_operator.oprleft = pg_type.oid
and pg_type.typname = "oid"
Success
Pblank - 1 columns, 7 lines
Postquel
retrieve(sic.all,sic.oid)
Success
Pblank - 3 columns, 1 lines
Postquel
replace sic (name="the firt record"
) where sic.oid = "161504::oid"
Error
Postquel error: R
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: tjw00@spg.amdahl.com
Subject: Re: Question about a pgbrowse error i am getting with postgres 4.2
In-Reply-To: <9404252148.AA00629@petal.spg.amdahl.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox