Delivery-Date: Mon, 25 Apr 94 17:53:28 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199404252148.OAA05787@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Mon, 25 Apr 94 14:48:48 PDT
From: tjw00@spg.amdahl.com (Tom Wye)
Message-Id: <9404252148.AA00629@petal.spg.amdahl.com>
To: postgres@postgres.Berkeley.EDU
Subject: Question about a pgbrowse error i am getting with postgres 4.2
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 25 Apr 94 14:48:52 -0700
Resent-XMts: smtp

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