Re: UNIQUE INDEX difference between 7.2 and 7.3

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?