The following bug has been logged online:
Bug reference: 1169
Logged by: Robert Osowiecki
Email address: robson@cavern.pl
PostgreSQL version: 7.4
Operating system: Linux
Description: Select table.oid from view seems to loop
Details:
Hello!
Here's what i found:
select count(*) from view1;
count
-------
12874
(1 row)
select table1.oid from view1;
NOTICE: adding missing FROM-clause entry for table "table1"
(psql crashes)
select table1.ord from view1 limit 13000;
(13000 rows in result)
Hope it helps: feel free to ask for more details by email.
Yours,
Robson.