On Fri, 11 Nov 2005 kevin@mtel.co.uk wrote:
> hi, i've got a test system under fedora 4/ 8.04 postgres that works
> fine. I installed 8.1 on a production machine using redhat 9, and weird
> errors start happening.
>
> this will produce true in 8.04 but not 8.1. There are other (similar)
> statements against these tables that have stopped working.
> the tables are defines as follows
>
That's certainly a strange one. I see no reason for plain string
comparisons to fail randomly. My only guess would be some sort of
locale/encoding issue. Are both databases using the same locale and
encoding? What do you get from "SHOW lc_collate;" and "SHOW
server_encoding;" on each? This seems especially bizarre given that it
works from psql (implying something might be wrong converting from
client_encoding to the server_encoding) and also that you have such
vanilla values for these parameters ("ADMIN" and such, not unusual
characters from distant parts of the world.)
Kris Jurka