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