On Thu, 17 Jun 2004, PostgreSQL Bugs List wrote: > 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)
Note the notice. IIRC the above is technically invalid SQL, but PostgreSQL tries to do what it thinks you want which is to transform it into: select table1.oid from view1, table1; There's a GUC variable (add_missing_from) which allows you to control whether it does the transform. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
