Postgres Pro
Downloads
Home   >   mailing lists

Re: regular expression and index on 7.2 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: regular expression and index on 7.2
Date
Msg-id 26181.1019833162@sss.pgh.pa.us
Whole thread Raw
In response to regular expression and index on 7.2  (Holger Dörl <holger.doerl@web.de>)
List pgsql-bugs
Tree view 
Holger Dörl <holger.doerl@web.de> writes:
> Do you have any idea why it dosn't work with 7.2 ????

Perhaps you initdb'd 7.2 in a non-C locale?  (contrib/pg_controldata
is the way to check if you're not sure.)

> And what can I do to use the index ????

re-initdb is the only way to change the database locale if it's
wrong :-(
        regards, tom lane

pgsql-bugs by date:

Previous
From: stev knowles
Date:
Subject: problem with SELECT DISTINCT against an empty column
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #650: using a trigger like a sequence doesn't work