John Lumby <johnlu...@hotmail.com> writes: > Sorry about that, here is a script to demonstrate using a much simpler > example. > It presumes linux and that there is a bash shell at /bin/bash.
> You should see table created and loaded (takes a few minutes), then > successful query explain and run, > then create index and re-run the explain (now uses index) and query (now > fails) Hmm ... I tried this script on both HEAD and 9.1, and see no failure. Possibly it requires some non-default configuration setting to show the problem? Also, are you certain your database is ending up with LC_COLLATE and LC_CTYPE set to "C"? I am not sure that createdb pays attention to those as locale settings. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs