The following bug has been logged online:
Bug reference: 5316
Logged by: Gianfranco Frau
Email address: frau(at)crs4(dot)it
PostgreSQL version: 8.2.11
Operating system: Ubuntu
Description: not handled error in inherit queries
Details:
if you make this query:
SELECT * from first_table where one in (SELECT one from second_table);
and "second_table" don't have an "one" column, no errors are reported, but
seems that the internal query returns a empty set.
If you do:
SELECT one from second_table;
the error is correctly reported.