| From: | Allan Engelhardt <allane(at)cybaea(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Character collating order |
| Date: | 2001-07-03 20:10:07 |
| Message-ID: | 3B42269F.E6D9DE58@cybaea.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Tom Lane wrote:
> Allan Engelhardt <allane(at)cybaea(dot)com> writes:
> > I'm using the SQL_ASCII encoding, and un-setting the LANG environment
> > variable (which is the only locale variable set for the account; it
> > defaults to en_US) for postgres when starting postmaster does not fix
> > it.
>
> In 7.1, collation is determined by the locale variables seen at initdb
> time. You probably need to re-initdb with LANG=C. Try
> contrib/pg_controldata to verify the guess that the database's locale
> is not C ...
Bingo! Re-init and re-start fixes the test script. Now I just need to figure out how I want to run my database.........
Thanks a million: you're a hero.
Allan.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | suhail sarwar | 2001-07-04 09:56:14 | Date/Time insertions in postgres |
| Previous Message | Allan Engelhardt | 2001-07-03 19:54:45 | Re: Regression on 7.1.2 fails 17/76 - is it up to date? |