Re: [GENERAL] query that worked in 8.1 not working in 8.4

2009-08-27 Thread Sean Foreman
Thanks Tom. That is what I suspected. I will install the branch tip on Monday and see if the problem goes away. Sean Tom Lane wrote: Sean Foreman writes: We recently upgraded postgres from 8.1 to 8.4. One of our queries stopped working and after some digging I've narrowed the pr

Re: [GENERAL] query that worked in 8.1 not working in 8.4

2009-08-27 Thread Sean Foreman
a bug. On Thu, Aug 27, 2009 at 2:13 PM, Sean Foreman wrote: We recently upgraded postgres from 8.1 to 8.4. One of our queries stopped working and after some digging I've narrowed the problem down to this: table structure of interest: merchant_set merchant_set_id merchant m

Re: [GENERAL] query that worked in 8.1 not working in 8.4

2009-08-27 Thread Sean Foreman
There is no error message. Posgres "likes" the query. In this case, the query returns a count of 1 instead of 3562. Scott Marlowe wrote: On Thu, Aug 27, 2009 at 2:13 PM, Sean Foreman wrote: We recently upgraded postgres from 8.1 to 8.4. So, is there an error message you ge

[GENERAL] query that worked in 8.1 not working in 8.4

2009-08-27 Thread Sean Foreman
We recently upgraded postgres from 8.1 to 8.4. One of our queries stopped working and after some digging I've narrowed the problem down to this: table structure of interest: merchant_set merchant_set_id merchant merchant_id merchant_set_id customer customer_id merchant_set_id -- failure (c