"gerrit" <[EMAIL PROTECTED]> writes:
> --this is the problem - cant get this thing to use indexes on city and
> capital
> explain select * from suburb, cities where suburb.name = 'abc' and city_id
> = id ;
In CVS HEAD I get
regression=# explain select * from suburb, cities where suburb.name = '
The following bug has been logged online:
Bug reference: 2623
Logged by: gerrit
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: red hat linux
Description:query optimizer not using indexes with inheritance and
joins
Details:
Hi, I've got