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

SELECTs return error with oid in WHERE clause

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: SELECTs return error with oid in WHERE clause
Date: 2000-10-17 15:32:43
Message-ID: 200010171532.e9HFWhC21361@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Ilya Goldberg (igg(at)mit(dot)edu) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
SELECTs return error with oid in WHERE clause

Long Description
Create a table (FOO) insert a row, do a SELECT oid from FOO.  Now do a SELECT FROM FOO WHERE OID=[whatever was returned in the last command].
Result is an error:
ERROR:  getattproperties: no attribute tuple 29194 -2
The number after 'tuple' is table-specific rather than oid specific.
In the example above, the OID was actually 29203.
This occurs through psql, Pg.pm, and PsqlODBC.  The latter essentially breaks the driver as used by Excel.
PostgreSQL 7.0.2 on powerpc-unknown-linux-gnu, compiled by gcc 2.95.2


Sample Code
A psql session:
ome=# create table foo (bar integer);
CREATE
ome=# insert into foo values (123);
INSERT 29203 1
ome=# select * from foo where oid=29203;
ERROR:  getattproperties: no attribute tuple 29194 -2


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Ilya GoldbergDate: 2000-10-17 16:00:27
Subject: OID in WHERE clause of SELECT results in error
Previous:From: Tom RogersDate: 2000-10-17 14:47:40
Subject: Bugs in to_char function

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