From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
---|---|
To: | Postgres General List <pgsql-general(at)postgresql(dot)org> |
Subject: | 8.3 vs 8.2 sql compatiblity issue |
Date: | 2007-11-15 18:03:27 |
Message-ID: | 473C89EF.2030405@amsoftwaredesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Just running some queries that have worked from 7.4 through 8.2 and they
don't seem to work on 8.3.
select case when a.attnum = any(conkey) then true else false end from
pg_constraint where contype = 'p' and conrelid = c.oid
This one is puking on a.attnum = any(conkey)
returns the following error:
SQL State: 42883
ERROR: operator does not exist: smallint = text
HINT: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
0 Record(s) Returned
--------------------------------------------------------------------
I am actually getting a lot of these operator does not exist errors in 8.3
another one I get is operator does not exist for char=integer
i.e.
attnum = pi.indkey[0]) used to work but fails in 8.3
Ideas?
Thanks,
Tony
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2007-11-15 18:03:48 | Re: pg_dump problem |
Previous Message | Joshua D. Drake | 2007-11-15 17:50:05 | Re: PLpgsql debugger question |