Re: [BUGS] BUG #2623: query optimizer not using indexes with inheritance and joins

2006-09-13 Thread Tom Lane
"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 = '

[BUGS] BUG #2623: query optimizer not using indexes with inheritance and joins

2006-09-13 Thread gerrit
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