Ilya Goldberg ([EMAIL PROTECTED]) 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

Reply via email to