Ranga, * Ranga Gopalan (ranga_gopa...@hotmail.com) wrote: > It seems that this is an issue faced by others as well - Please see this > link: > http://stackoverflow.com/questions/2236776/efficient-querying-of-multi-partition-postgres-table > > Is this a known bug? Is this something that someone is working on or is there > a known work around?
Actually, if you look at that, the problem the original poster had was that they didn't have constraint_exclusion turned on. Then they were complaining about having the (empty) master table and the needed partition included (which, really, shouldn't be that big a deal). Did you look at what the other reply suggested? Do you have constraint_exclusion = 'on' in your postgresql.conf? Thanks, Stephen
signature.asc
Description: Digital signature