From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Kevin Houle <kjh(at)cert(dot)org> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: UNIQUE INDEX difference between 7.2 and 7.3 |
Date: | 2003-08-12 15:47:08 |
Message-ID: | 20030812083818.U12578-100000@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, 12 Aug 2003, Kevin Houle wrote:
> >> There is an email attachment (md5: 5cc780da645df9516235d43d1cf1e8b5)
> >> which contains a file with two SQL INSERT commands to insert two rows
> >> into a test table. The table should look like this:
> >>
> >> CREATE TABLE tbl_test (
> >> testcol text,
> >> unique (testcol)
> >> );
> >>
> >> The databases in my testing are using SQL_ASCII encoding.
> >
> > I don't receive an error on my 7.3.4 system, what locale is the database
> > initialized in?
>
> I'm using defaults, so on RH9 it is:
>
> /var/lib/pgsql/initdb.i18n:
> LANG="en_US.UTF-8"
Okay, I see it with en_US.UTF-8, but not with C locale, nor with
en_US or en_US.iso885915. It looks like the comparison rules are
different between the locales (and I'm not sure if SQL_ASCII encoding
and a UTF8 locale makes sense in practice).
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Houle | 2003-08-12 16:55:00 | Re: UNIQUE INDEX difference between 7.2 and 7.3 |
Previous Message | Kevin Houle | 2003-08-12 15:28:56 | Re: UNIQUE INDEX difference between 7.2 and 7.3 |