The following bug has been logged online:

Bug reference:      5316
Logged by:          Gianfranco Frau
Email address:      [email protected]
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.

-- 
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to