On Thu, Aug 27, 2009 at 2:13 PM, Sean
Foreman<sean(dot)foreman(at)mpaygateway(dot)com> 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
> merchant_id
> merchant_set_id
>
> customer
> customer_id
> merchant_set_id
So what data types are these? I'm guessing you're being bitten by
some auto-cast that got removed in 8.3. But that's just a guess.