Re: UNIQUE INDEX difference between 7.2 and 7.3

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

- --On Tuesday, August 12, 2003 08:18:53 AM -0700 Stephan Szabo
<sszabo@megazone
.bigpanda.com> wrote:

>
> On Tue, 12 Aug 2003, Kevin Houle wrote:
>
>> System Configuration
>> - ----------------------
>>   Architecture : i686
>>
>>   Operating System : RH9, 2.4.20-19
>>
>>   PostgreSQL version :  PostgreSQL-7.3.4 (RPMS from PGDG)
>>
>> Please enter a FULL description of your problem:
>> - -------------------------------------------------
>>
>> 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"

and on RH7.3 it is:

  /var/lib/pgsql/initdb.i18n:
   LANG="en_US"

Kevin



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/OQeiu/NTC+XTbEkRAqyCAJ9dWKLKDy7ikbFFNwc6bzt7rEqj+wCfevAe
LOaw4FFNrbr6wdtl0Zls+cU=
=X2Z2
-----END PGP SIGNATURE-----