Re: query that worked in 8.1 not working in 8.4 - Mailing list pgsql-general

On Thu, Aug 27, 2009 at 2:13 PM, Sean
Foreman<sean.foreman@mpaygateway.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.