Re: [GENERAL] regular expression limit

2007-01-02 Thread Tom Lane
Ron Peterson <[EMAIL PROTECTED]> writes: >> Sorry, I don't believe 8.1 took it either. > Hmm, my test table fails in 8.1.4 also, but my actual use case works in > 8.1.4 but not 8.2. You haven't shown us exactly what that C function is doing, but my interpretation of that is that 8.1 failed to che

Re: [GENERAL] regular expression limit

2007-01-02 Thread Ron Peterson
On Mon, Jan 01, 2007 at 11:30:00PM -0500, Tom Lane wrote: > Ron Peterson <[EMAIL PROTECTED]> writes: > > I believe there's been a change in PostgreSQL's regular expression > > handling w/ 8.2. > > Compared to what? A repeat count of 256 has been an error at least > since 7.4, and is documented as

Re: [GENERAL] regular expression limit

2007-01-01 Thread Tom Lane
Ron Peterson <[EMAIL PROTECTED]> writes: > I believe there's been a change in PostgreSQL's regular expression > handling w/ 8.2. Compared to what? A repeat count of 256 has been an error at least since 7.4, and is documented as such: : The numbers m and n within a bound are unsigned decimal inte

[GENERAL] regular expression limit

2007-01-01 Thread Ron Peterson
I believe there's been a change in PostgreSQL's regular expression handling w/ 8.2. CREATE TABLE testb ( name TEXT --CHECK( name ~ '^[a-f0-9]{1,256}$' ) CHECK( name ~ '^[a-f0-9]{1,255}$' ) ); If I swap the two check statements above, I can no longer insert data. The operation errors