[9.1beta1] UTF-8/Regex Word-Character Definition excluding accented letters

From: "David Johnston" <polobo(at)yahoo(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: [9.1beta1] UTF-8/Regex Word-Character Definition excluding accented letters
Date: 2011-05-31 01:04:24
Message-ID: 002501cc1f2e$af704930$0e50db90$@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

PostgreSQL 9.1beta1, compiled by Visual C++ build 1500, 64-bit (EnterpriseDB
Install Executable)

CREATE DATABASE betatest

TEMPLATE template0

ENCODING 'UTF8'

LC_COLLATE 'C'

LC_CTYPE 'C';

[connect to database]

CREATE DOMAIN idcode AS text

NOT NULL CHECK (VALUE ~* '^\w[-:\w]*$')

;

SELECT 'AAAAAéaaaaa'::idcode; // -> SQL Error: ERROR: value for domain
idcode violates check constraint "idcode_check" (note the accented “e”
between all the “A”s)

This is running just fine against a 9.0 install on the same machine. [\w]
is Unicode aware and server encoding is set (and confirmed via SHOW) to be
“UTF8”.

David J.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-05-31 02:14:08 Re: UTC4115FATAL: the database system is in recovery mode
Previous Message Craig Ringer 2011-05-30 23:51:44 Re: UTC4115FATAL: the database system is in recovery mode