BUG #2293: primary key and cyrillic

From: "Sergey Rosenfeld" <serg(at)ung(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2293: primary key and cyrillic
Date: 2006-03-01 15:30:08
Message-ID: 20060301153008.8E9ADF0B03@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2293
Logged by: Sergey Rosenfeld
Email address: serg(at)ung(dot)ru
PostgreSQL version: 8.1.3
Operating system: Debian GNU/Linux (sid)
Description: primary key and cyrillic
Details:

postgres:~$ /usr/lib/postgresql/8.1/bin/pg_controldata
/var/lib/postgresql/8.1/main
<...skipped cyrillic koi8-r output ...>
LC_COLLATE: ru_RU.koi8r
LC_CTYPE: ru_RU.koi8r

postmaster works in same locale environment

postgres:~$ psql
Welcome to psql 8.1.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

postgres=# select version();
version
----------------------------------------------------------------------------
----------------------------------
PostgreSQL 8.1.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3
20060212 (prerelease) (Debian 4.0.2-9)
(1 )

postgres=# show server_encoding;
server_encoding
-----------------
KOI8
(1 )

postgres=# show client_encoding;
client_encoding
-----------------
KOI8
(1 )
postgres=# create table test( s varchar(20) primary key );
NOTICE: CREATE TABLE / PRIMARY KEY
"test_pkey"
"test"
CREATE TABLE
postgres=# \d test
"public.test"
| |
---------+-----------------------+--------------
s | character varying(20) | not null
:
"test_pkey" PRIMARY KEY, btree (s)

postgres=# insert into test values( ' ' );
INSERT 0 1
postgres=# insert into test values( ' ' );
INSERT 0 1
postgres=# select * from test;
s
-----------


(: 2)

What about PRIMARY KEY? If i use ascii symbols, all works fine:

postgres=# insert into test values( 'asdf asdf' );
INSERT 0 1
postgres=# insert into test values( 'asdf asdf' );
ERROR:
UNIQUE "test_pkey"

Browse pgsql-bugs by date

  From Date Subject
Next Message SPI_connect() failure. 2006-03-01 18:36:25 BUG #2294: SPI_connect() fails in trigger when a Foreignkey constraint exists on same table as trigger.
Previous Message Adriaan van Os 2006-03-01 13:08:17 BUG #2292: Calling conventions in docs