Postgres Pro
Downloads
Home   >   mailing lists

Thread: regular expression limit

regular expression limit

From
Ron Peterson
Date:
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 out with:

"invalid regular expression: invalid repetition count(s)"

I'd like the following domain statement to work.  It used to work in
8.1.4, but not now.  Can I do this in 8.2?

CREATE DOMAIN
  __hex_string_8192
AS TEXT
CHECK ( VALUE ~ '^[a-f0-9]{1,8192}$' );

TIA.

--
Ron Peterson
https://www.yellowbank.com/

Re: regular expression limit

From
Tom Lane
Date:
Ron Peterson <ron.peterson@yellowbank.com> 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 integers with
: permissible values from 0 to 255 inclusive.

> I'd like the following domain statement to work.  It used to work in
> 8.1.4, but not now.

Sorry, I don't believe 8.1 took it either.  Consider separating your
concerns, eg

    CHECK( length(VALUE) <= 8192 AND VALUE ~ '^[a-f0-9]+$' )

            regards, tom lane

Re: regular expression limit

From
Ron Peterson
Date:
On Mon, Jan 01, 2007 at 11:30:00PM -0500, Tom Lane wrote:
> Ron Peterson <ron.peterson@yellowbank.com> 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 integers with
> : permissible values from 0 to 255 inclusive.
>
> > I'd like the following domain statement to work.  It used to work in
> > 8.1.4, but not now.
>
> 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.

CREATE DOMAIN
  __hex_string_8192
AS TEXT
CHECK ( VALUE ~ '^[a-f0-9]{1,8192}$' );

CREATE TYPE __rsa_keys AS (
  n
    __hex_string_8192,
  e
    __hex_string_8192,
  d
    __hex_string_8192
);

CREATE OR REPLACE FUNCTION
  y_pkcs_generate_rsa_keys(rd TEXT, sl INTEGER, mb INTEGER)
RETURNS
  __rsa_keys
AS
  'y_pkcs.so', 'y_pkcs_generate_rsa_keys'
LANGUAGE
  C
STRICT IMMUTABLE;

When I call y_pkcs_generate_rsa_keys in 8.1.4 it works.  When I call
this function in 8.2 it fails with the regular expression limit error.

I'll just revise my constraint as you suggested.

> Consider separating your concerns, eg
>
>     CHECK( length(VALUE) <= 8192 AND VALUE ~ '^[a-f0-9]+$' )

That works for me.  Thanks.

--
Ron Peterson
https://www.yellowbank.com/

Re: regular expression limit

From
Tom Lane
Date:
Ron Peterson <ron.peterson@yellowbank.com> 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 check the domain
constraints at all, while 8.2 does it correctly.

            regards, tom lane