The following bug has been logged online:
Bug reference: 1169 Logged by: Robert Osowiecki
Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux Description: Select table.oid from view seems to loop
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)
This statement is probably not what you meant to say. There is no "table1.oid" in view1, so PG is adding a reference to table1, turning your query into:
SELECT table1.oid FROM view1, table1;
This gives you the product of both relations, e.g. if you have 2000 rows in view1 and 3000 in table1 that's 6,000,000 rows in total. You probably run out of memory somewhere which looks like a crash.
In 7.4 there is a postgresql.conf setting to control this behaviour (add_missing_from). I'd turn it off, as I've always found it to cause problems rather than solve them.
HTH -- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
