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"
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 |