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
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
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
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