On Thu, Aug 27, 2009 at 2:13 PM, Sean Foreman<sean.foreman@xxxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
