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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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