BUG #11523: Regular expressions work differently on different platforms

From: dmigowski(at)ikoffice(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11523: Regular expressions work differently on different platforms
Date: 2014-09-30 09:56:25
Message-ID: 20140930095625.7631.32436@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11523
Logged by: Daniel Migowski
Email address: dmigowski(at)ikoffice(dot)de
PostgreSQL version: 9.1.2
Operating system: Debian Linux 6.0.6 + Windows 7
Description:

I recently found that regular expressions, or specifically the [:space:]
shorthand escape work differntly on Windows and Linux. On Linux the
non-brakeable space is not included in the shorthand escape, on windows it
is. The following statement is therefore true on Windows and false on
Linux:

select convert_from(E'\\xA0'::bytea,'ISO8859-1') ~ '\s'

This brakes email validation here, and the insert of a linux created backup
into my windows machine. Is it possible to fix that? Is there a reason that
UTF-8 on Linux differs from UTF-8 on Windows?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message feikesteenbergen 2014-09-30 10:43:30 BUG #11524: Unable to add value to ENUM when having AUTOCOMMIT disabled in psql
Previous Message Michael Paquier 2014-09-30 08:04:48 Re: BUG #11457: The below query crashes 9.3.5, but not 9.3.4