--- Tom Lane <[EMAIL PROTECTED]> wrote: > It seems risky, but you could probably get away with that as long > as the database locale (LC_COLLATE/LC_CTYPE) is "C" ... which is really > the only one that's safe with SQL_ASCII anyway ...
I actually created the cluster with: test1:~# /usr/lib/postgresql/8.1/bin/initdb --pwprompt -D /var/lib/postgresql/8.1/main/ --lc-collate=POSIX test1:~# locale LANG= LC_CTYPE="POSIX" LC_NUMERIC="POSIX" LC_TIME="POSIX" LC_COLLATE="POSIX" LC_MONETARY="POSIX" LC_MESSAGES="POSIX" LC_PAPER="POSIX" LC_NAME="POSIX" LC_ADDRESS="POSIX" LC_TELEPHONE="POSIX" LC_MEASUREMENT="POSIX" LC_IDENTIFICATION="POSIX" LC_ALL= Not sure if it's going to make a difference. Thanks __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
