SELECTs return error with oid in WHERE clause
От | pgsql-bugs@postgresql.org |
---|---|
Тема | SELECTs return error with oid in WHERE clause |
Дата | |
Msg-id | 200010171532.e9HFWhC21361@hub.org обсуждение исходный текст |
Ответы |
Re: SELECTs return error with oid in WHERE clause
|
Список | pgsql-bugs |
Ilya Goldberg (igg@mit.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 inthe 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
В списке pgsql-bugs по дате отправления: