"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> writes: > Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> wrote: >> 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 > This appears to be a classic example of: > Casts to text that formerly occurred implicitly may now need to be > written explicitly That's no doubt got something to do with it, but I think Tony is mighty confused about exactly what is failing. pg_constraint.conkey is not text, for instance; it's smallint[] and so the quoted bit should still work just fine. I'd suggest trying the query in some client that gives you an error location pointer, which whatever he's using evidently does not. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
