Re: There is a doubt of fatal bug on PostgreSQL 8.0.4. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: There is a doubt of fatal bug on PostgreSQL 8.0.4.
Date
Msg-id 1732.1134163406@sss.pgh.pa.us
Whole thread Raw
In response to Re: There is a doubt of fatal bug on PostgreSQL 8.0.4.  ("Kasahara Kenichi" <kenjpm90@hotmail.com>)
List pgsql-bugs
"Kasahara Kenichi" <kenjpm90@hotmail.com> writes:
>> What locale is the database using?  Strange comparison behavior is
>> fairly common if the locale expects a different encoding than you
>> are using...

> locale is 'C'.

Hm, it should work OK with C locale.  I get apparently-correct output
on my 8.0 installation:

CREATE TABLE
INSERT 155246 1
INSERT 155247 1
INSERT 155248 1
 id |     name
----+--------------
 1  | $B$"$"$"(B
(1 row)

 id | name
----+------
(0 rows)

> client_encoding is 'SJIS'.

Um ... you said EUC_JP before.  But I get the same result either way.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #2100: CREATE TABLE AS - may not supply table specification
Next
From: David Fetter
Date:
Subject: Re: [PATCHES] Patch to allow contrib/pgbench files to have blank lines