Bug #910: query with inherits

Igor (programer_c(at)land(dot)ru) reports a bug with a severity of 4
The lower the number the more severe it is.

Short Description
query with inherits

Long Description
In the next situation:
CREATE TABLE main (f1 int4 NOT NULL, PRIMARY KEY(f1));
CREATE TABLE derived (f2 int4) INHERIT (main);
CREATE TABLE other (f3 int4, f1 int1 NOT NULL);
expression
explain analyze SELECT * FROM main WHERE f1=1;
executed by index scan main and derived,
but expression
explain analyze SELECT * FROM main m, other o WHERE o.f3=1 AND o.f1=m.f1;
executed by seq scan main and derived. Why?

Best regard with Russia!

Sample Code

No file was uploaded with this report