Re: [HACKERS] planner issue with constraint exclusion

2008-12-15 Thread Tom Lane
"Joshua D. Drake" writes: > On Mon, 2008-12-15 at 14:28 -0500, Tom Lane wrote: >> "Joshua D. Drake" writes: >>> Of the functions the only one that will use constraint_exclusion is the >>> one that explicitly passes the date value. >> >> Since you haven't shown us the constraints you're talking a

Re: [HACKERS] planner issue with constraint exclusion

2008-12-15 Thread Stephen Frost
* Joshua D. Drake (j...@commandprompt.com) wrote: > On Mon, 2008-12-15 at 14:28 -0500, Tom Lane wrote: > > "Joshua D. Drake" writes: > > > Of the functions the only one that will use constraint_exclusion is the > > > one that explicitly passes the date value. > > > > Since you haven't shown us th

Re: [HACKERS] planner issue with constraint exclusion

2008-12-15 Thread Joshua D. Drake
On Mon, 2008-12-15 at 14:28 -0500, Tom Lane wrote: > "Joshua D. Drake" writes: > > Of the functions the only one that will use constraint_exclusion is the > > one that explicitly passes the date value. > > Since you haven't shown us the constraints you're talking about, or the > resulting plans,

Re: [HACKERS] planner issue with constraint exclusion

2008-12-15 Thread Tom Lane
"Joshua D. Drake" writes: > Of the functions the only one that will use constraint_exclusion is the > one that explicitly passes the date value. Since you haven't shown us the constraints you're talking about, or the resulting plans, it's difficult for anyone to guess what's going on.

[HACKERS] planner issue with constraint exclusion

2008-12-15 Thread Joshua D. Drake
Hello, I ran into this problem recently: https://projects.commandprompt.com/public/replicator/pastebin?show=f1288d4d8%0D Of the functions the only one that will use constraint_exclusion is the one that explicitly passes the date value. I kind of get why except for the one that uses EXECUTE. As E