Richard van den Berg wrote: > During the > pg_restore, it complained about failing to create several indexes > because of duplicates. Inspecting these cases showed that the bogus > characters are to blame. It seems that these characters (that are > probably not defined in LATIN1) are now turned into wildcards: they will > match any other character. Is this an expected result from running a non > SQL_ASCII database? It should depend on the locale. Can you tell the results of `show lc_ctype` and `show lc_collate`? -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
