From bd.postgres@gmail.com Thu May 27 19:34:33 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 99B1D636FCD for ; Thu, 27 May 2010 16:34:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 69927-04-3 for ; Thu, 27 May 2010 19:34:25 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-px0-f174.google.com (mail-px0-f174.google.com [209.85.212.174]) by mail.postgresql.org (Postfix) with ESMTP id 7C9AC6343FF for ; Thu, 27 May 2010 16:33:10 -0300 (ADT) Received: by pxi18 with SMTP id 18so180394pxi.19 for ; Thu, 27 May 2010 12:33:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=h8VJiqZ0l1IXpHd//Ty0G+RO57QyHsbY0Y6CD6JXMUc=; b=fszddR+abeBbo9GgSFWxpLx00GxpKQSwN8fmWQqewe+lJy0sklGPcbs3XNNwz0DLAe lfvzY3iunxrAJXDIHrKBkdFGbEX75qCSE/aqxebg5j4fLFNZOypk2+BCLMKYmv7l/kF6 FBAFGcvTI2/Q51zIIJ7lgXn6uqShpRA4w/yzQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=PM3cKzilDJAacmVN6uKTW4IQlH+0XwYOH1eO4TtZjZs6zYeofc0TshU+Yv/j1hEo1W rH3fChEp01FaSaNT/c+ZKrkLiX/FUWTdLESEg3UDsHInoXnG3Smiu7AItRgSo+piOU1I 6oD+UnCLFDKL1vMmZPUIXf4GBFbK9hulX54Ng= MIME-Version: 1.0 Received: by 10.142.121.1 with SMTP id t1mr7596192wfc.100.1274988787414; Thu, 27 May 2010 12:33:07 -0700 (PDT) Received: by 10.142.194.4 with HTTP; Thu, 27 May 2010 12:33:07 -0700 (PDT) Date: Thu, 27 May 2010 13:33:07 -0600 Message-ID: Subject: Extending Regular Expression bounds limit of 255. From: Brent DeSpain To: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=001636e9083dc435d10487987563 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=-5 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201005/133 X-Sequence-Number: 34181 --001636e9083dc435d10487987563 Content-Type: text/plain; charset=ISO-8859-1 In the docs http://www.postgresql.org/docs/8.3/interactive/functions-matching.html#POSIX-EMBEDDED-OPTIONS-TABLE it says that Regular Expression bounds {m,n} that m and n can be 0-255. Is there a way to extend the upper limit. We are trying to be consistent between Regular Expressionimplementation an the other implementations do not have this limit. Brent DeSpain Schweitzer Engineering Laboratories, Inc. --001636e9083dc435d10487987563 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable In the docs http://www.postgresql.org/= docs/8.3/interactive/functions-matching.html#POSIX-EMBEDDED-OPTIONS-TABLE
it says that Regular Expression bounds {m,n} that m and n can be 0-255.=A0 = Is there a way to extend the upper limit.=A0 We are trying to be consistent= between Regular Expressionimplementation an the other implementations do n= ot have this limit.

Brent DeSpain
Schweitzer Engineering Laboratories, Inc= .
--001636e9083dc435d10487987563-- From andrej.groups@gmail.com Thu May 27 20:59:15 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id BF376632538 for ; Thu, 27 May 2010 17:59:15 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 16009-07 for ; Thu, 27 May 2010 20:59:05 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-px0-f174.google.com (mail-px0-f174.google.com [209.85.212.174]) by mail.postgresql.org (Postfix) with ESMTP id 38E08632523 for ; Thu, 27 May 2010 17:59:06 -0300 (ADT) Received: by pxi18 with SMTP id 18so214574pxi.19 for ; Thu, 27 May 2010 13:59:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=6id3coWE146yTeg+pF2oHilnBafgwoaS79iMDWJCFwI=; b=eb0D10RmdZdB+ndNdnl50yPJMhPeOm2JS6vCaVsnNywlZlWC3cRGE8Y+UImbkJHO2T yY1rELemDMDb3JZPTLPG8VI24yx2W2mi7FSUH89nxVp+u7IWcWojv4eTJekFutpnvtrB riQeZdSnwD6+LzUWvacb9xiYyzew/T1RGNrCc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=XD+jWjEr5DClW3tvLHg4tNjycIyNeIwDr/pWeeHvI0mXgSWh/nuv217s8VnOtwZOf/ /7Zf1SW5oT3NCV3VAkl5XcHym5j8ZALgMi9z96kf7NVcBFNrysjt/+lkRBqILoSn8RNI r1JasxAbX/Rg62KPST5Q97UOHBC2ZlofjGyqI= MIME-Version: 1.0 Received: by 10.142.55.18 with SMTP id d18mr7593356wfa.170.1274993944600; Thu, 27 May 2010 13:59:04 -0700 (PDT) Received: by 10.143.159.11 with HTTP; Thu, 27 May 2010 13:59:04 -0700 (PDT) In-Reply-To: References: Date: Fri, 28 May 2010 08:59:04 +1200 Message-ID: Subject: Re: Extending Regular Expression bounds limit of 255. From: Andrej To: Brent DeSpain Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201005/134 X-Sequence-Number: 34182 On 28 May 2010 07:33, Brent DeSpain wrote: > In the docs > http://www.postgresql.org/docs/8.3/interactive/functions-matching.html#PO= SIX-EMBEDDED-OPTIONS-TABLE > it says that Regular Expression bounds {m,n} that m and n can be 0-255.= =A0 Is > there a way to extend the upper limit.=A0 We are trying to be consistent > between Regular Expressionimplementation an the other implementations do = not > have this limit. Interesting. The POSIX standard for REs dictates this limit; which implementations you're using don't adhere to it? Cheers, Andrej --=20 Please don't top post, and don't use HTML e-Mail :} Make your quotes conci= se. http://www.american.edu/econ/notes/htmlmail.htm From bd.postgres@gmail.com Thu May 27 22:44:10 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 6116F6326D7 for ; Thu, 27 May 2010 19:44:10 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 80051-09 for ; Thu, 27 May 2010 22:44:01 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-px0-f174.google.com (mail-px0-f174.google.com [209.85.212.174]) by mail.postgresql.org (Postfix) with ESMTP id 780A16325EF for ; Thu, 27 May 2010 19:44:02 -0300 (ADT) Received: by pxi18 with SMTP id 18so248818pxi.19 for ; Thu, 27 May 2010 15:44:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=yIRwk8bDAb+YjZ7t18rBYE14x1mOfVyLDfoEYFttMng=; b=J/xmtywpPgVGiec49qVsxfpCM97W+fNXM90GEI0f/V1WqIph9rSfaLrWTEtp+RWlBH wDjl+jS3YFBn1KvzkIB9+TjsEsEPmpsgdnNekT4OFV+hrZzDRqRzvvkdJKTRxilnwFnm zBZ+cm4rK8/VrqOMxZZjGpzftDWKj2bWcuArk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=nvxaspVLnINMjvnnYKmQXidQ3gFs+Befe6lHUIsVWRsKq2JC/j4c8B4eXADsXZvmT3 jhRAQ1yvVlVv5vyaUJWV8i59kUunQ0hWYt9X65kuy00lA0FlDOfAyvTRFwGn9DtqeNq0 l50qwj+rG2zzbMAUWl4KiixX9PNbnVCyV05sU= MIME-Version: 1.0 Received: by 10.142.55.7 with SMTP id d7mr7630768wfa.344.1275000240462; Thu, 27 May 2010 15:44:00 -0700 (PDT) Received: by 10.142.194.4 with HTTP; Thu, 27 May 2010 15:44:00 -0700 (PDT) In-Reply-To: References: Date: Thu, 27 May 2010 16:44:00 -0600 Message-ID: Subject: Re: Extending Regular Expression bounds limit of 255. From: Brent DeSpain To: Andrej Cc: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=0016368e26376bde0504879b200a X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=-5 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201005/135 X-Sequence-Number: 34183 --0016368e26376bde0504879b200a Content-Type: text/plain; charset=ISO-8859-1 No. Strangely enough they don't in enforce this limit. Brent DeSpain Schweitzer Engineering Laboratories, Inc. On Thu, May 27, 2010 at 2:59 PM, Andrej wrote: > On 28 May 2010 07:33, Brent DeSpain wrote: > > In the docs > > > http://www.postgresql.org/docs/8.3/interactive/functions-matching.html#POSIX-EMBEDDED-OPTIONS-TABLE > > it says that Regular Expression bounds {m,n} that m and n can be 0-255. > Is > > there a way to extend the upper limit. We are trying to be consistent > > between Regular Expressionimplementation an the other implementations do > not > > have this limit. > Interesting. The POSIX standard for REs dictates this limit; which > implementations > you're using don't adhere to it? > > > Cheers, > Andrej > > > > > -- > Please don't top post, and don't use HTML e-Mail :} Make your quotes > concise. > > http://www.american.edu/econ/notes/htmlmail.htm > --0016368e26376bde0504879b200a Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable No.=A0 Strangely enough they don't in enforce this limit.

Brent DeSpain
Schweitzer Engineering Laboratories, Inc.


On Thu, May 27, 2010 at 2:59 PM, Andrej = <andrej.gro= ups@gmail.com> wrote:
On 28 May 2010 07:33, Brent DeSpain <bd.postgres@gmail.com> wrote:
> In the docs
> http://www.post= gresql.org/docs/8.3/interactive/functions-matching.html#POSIX-EMBEDDED-OPTI= ONS-TABLE
> it says that Regular Expression bounds {m,n} that m and n can be 0-255= .=A0 Is
> there a way to extend the upper limit.=A0 We are trying to be consiste= nt
> between Regular Expressionimplementation an the other implementations = do not
> have this limit.
Interesting. =A0The POSIX standard for REs dictates this limit; which=
implementations
you're using don't adhere to it?


Cheers,
Andrej




--
Please don't top post, and don't use HTML e-Mail :} =A0Make your qu= otes concise.

http://www.american.edu/econ/notes/htmlmail.htm

--0016368e26376bde0504879b200a-- From bd.postgres@gmail.com Thu May 27 22:56:04 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D842E63233E for ; Thu, 27 May 2010 19:56:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 62828-01 for ; Thu, 27 May 2010 22:55:56 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-px0-f174.google.com (mail-px0-f174.google.com [209.85.212.174]) by mail.postgresql.org (Postfix) with ESMTP id B3E5B6322A7 for ; Thu, 27 May 2010 19:55:57 -0300 (ADT) Received: by pxi18 with SMTP id 18so252558pxi.19 for ; Thu, 27 May 2010 15:55:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=h+uY3URLIb5fvcEJqg6Dgek7/9hiGaiq9Vp4QzI62uY=; b=vjc8avclwBk16DOLxJkFiZB5tcb9bmgRYDFmK8GEfbyHgIbOPkPSggXpWHKJ0jHYTN FnigRFHyoQIyZM3uo2OCw4M/NruZ5tKS+aLI57iznIZ7Dz25mGWzVa7soXoCYjoC3rIE f2JAfAGwqBxMQ4N5j7n1lXaZtMN0rcTf/gJC0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=P9HF5GoLVbgPNjzxPij6A1zIoybCD6uOpYex7ocPbXF5embRTrjLHRzWb1DSqy9DJd WUasUm8/p39GR/GSYVQxiGXJF3uotP+nXLlwVjHMXuhAdi3vMXwFzzIyPUa/HsIEJCq7 xi4gup3BzbpM0LOdYDPDqHi7vGGNQHw+H4krY= MIME-Version: 1.0 Received: by 10.142.59.13 with SMTP id h13mr7847586wfa.168.1275000956032; Thu, 27 May 2010 15:55:56 -0700 (PDT) Received: by 10.142.194.4 with HTTP; Thu, 27 May 2010 15:55:55 -0700 (PDT) In-Reply-To: References: Date: Thu, 27 May 2010 16:55:55 -0600 Message-ID: Subject: Re: Extending Regular Expression bounds limit of 255. From: Brent DeSpain To: Andrej Cc: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=00504502c13812967604879b4ba3 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=-5 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201005/136 X-Sequence-Number: 34184 --00504502c13812967604879b4ba3 Content-Type: text/plain; charset=ISO-8859-1 It looks like most of our tools are using the Perl version of regular expressions with an upper limit of a bound being 32766. Is there any way to change this in PG? Or can I change from POSIX to Perl? Brent DeSpain Schweitzer Engineering Laboratories, Inc. On Thu, May 27, 2010 at 4:44 PM, Brent DeSpain wrote: > No. Strangely enough they don't in enforce this limit. > > > Brent DeSpain > Schweitzer Engineering Laboratories, Inc. > > > On Thu, May 27, 2010 at 2:59 PM, Andrej wrote: > >> On 28 May 2010 07:33, Brent DeSpain wrote: >> > In the docs >> > >> http://www.postgresql.org/docs/8.3/interactive/functions-matching.html#POSIX-EMBEDDED-OPTIONS-TABLE >> > it says that Regular Expression bounds {m,n} that m and n can be 0-255. >> Is >> > there a way to extend the upper limit. We are trying to be consistent >> > between Regular Expressionimplementation an the other implementations do >> not >> > have this limit. >> Interesting. The POSIX standard for REs dictates this limit; which >> implementations >> you're using don't adhere to it? >> >> >> Cheers, >> Andrej >> >> >> >> >> -- >> Please don't top post, and don't use HTML e-Mail :} Make your quotes >> concise. >> >> http://www.american.edu/econ/notes/htmlmail.htm >> > > --00504502c13812967604879b4ba3 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable It looks like most of our tools are using the Perl version of regular expre= ssions with an upper limit of a bound being 32766.=A0 Is there any way to c= hange this in PG?=A0 Or can I change from POSIX to Perl?

Brent DeSpain
Schweitzer Engineering Laboratories, Inc.


On Thu, May 27, 2010 at 4:44 PM, Brent D= eSpain <bd.po= stgres@gmail.com> wrote:
No.=A0 Strangely enough they don't in enforce this limit.


Brent DeSpain
Schweitzer Engineering Laborator= ies, Inc.


= On Thu, May 27, 2010 at 2:59 PM, Andrej <andrej.groups@gmail.com= > wrote:
On 28 May 2010 07:33, Brent DeSpain <bd.postgres@gmail.com> wrote:
> In the docs
> http://www.post= gresql.org/docs/8.3/interactive/functions-matching.html#POSIX-EMBEDDED-OPTI= ONS-TABLE
> it says that Regular Expression bounds {m,n} that m and n can be 0-255= .=A0 Is
> there a way to extend the upper limit.=A0 We are trying to be consiste= nt
> between Regular Expressionimplementation an the other implementations = do not
> have this limit.
Interesting. =A0The POSIX standard for REs dictates this limit; which=
implementations
you're using don't adhere to it?


Cheers,
Andrej




--
Please don't top post, and don't use HTML e-Mail :} =A0Make your qu= otes concise.

http://www.american.edu/econ/notes/htmlmail.htm


--00504502c13812967604879b4ba3-- From alvherre@commandprompt.com Fri May 28 15:14:57 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 44C50632E07 for ; Fri, 28 May 2010 12:14:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 89725-09 for ; Fri, 28 May 2010 15:14:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 03A6C62D9D2 for ; Fri, 28 May 2010 12:14:49 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 1E7DE348034; Fri, 28 May 2010 08:14:49 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id l8e9PlmlcCzq; Fri, 28 May 2010 08:14:47 -0700 (PDT) Received: from perhan.alvh.no-ip.org (unknown [190.95.4.86]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id B1D33348002; Fri, 28 May 2010 08:14:46 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 9A7AD6E81C; Fri, 28 May 2010 11:14:44 -0400 (CLT) Content-Type: text/plain; charset=UTF-8 Cc: Andrej , pgsql-sql Subject: Re: Extending Regular Expression bounds limit of 255. From: alvherre To: Brent DeSpain In-reply-to: References: Date: Fri, 28 May 2010 11:14:44 -0400 Message-Id: <1275059495-sup-4074@alvh.no-ip.org> User-Agent: Sup/0.11 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-5 required=5 tests=BAYES_40=-0.001 X-Spam-Level: X-Archive-Number: 201005/138 X-Sequence-Number: 34186 Excerpts from Brent DeSpain's message of jue may 27 18:55:55 -0400 2010: > It looks like most of our tools are using the Perl version of regular > expressions with an upper limit of a bound being 32766. Is there any way to > change this in PG? Or can I change from POSIX to Perl? See regcomp.c; you'll have to recompile. The interesting constant is DUPMAX (defined in regguts.h as per POSIX), but note that there's arithmetic in repeat() with those values. I wouldn't recommend doing any of this unless you have time to figure out whether the algorithms are efficient for larger values though. -- Álvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support From bd.postgres@gmail.com Fri May 28 15:44:37 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id DFC7C63287B for ; Fri, 28 May 2010 12:44:37 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 93756-09 for ; Fri, 28 May 2010 15:44:30 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pz0-f180.google.com (mail-pz0-f180.google.com [209.85.222.180]) by mail.postgresql.org (Postfix) with ESMTP id 8C9FF632538 for ; Fri, 28 May 2010 12:44:30 -0300 (ADT) Received: by pzk10 with SMTP id 10so747437pzk.20 for ; Fri, 28 May 2010 08:44:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=e79VbESSKGvCowcyAxt1gN7o2en0Li2Eif/K+zrMGnE=; b=KUmhquFyHimlSgMm0C/xVATa/N5F1nZoYrPlCxUbFDWyv242OaRq/MQk6V0suHt1xt 3U+RDYTTjYoW6aN1+lw5I3xqSWtp8pgUGPmoYPwwYeOpUBaSVRB+UHCZKPJdUiVZOwot ugdH8j9Vwt1G85Ym0aU5b54xC13Oe+trS7dWI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=wIKdj/6TO4V52yD7N+qVeaOaR1oogZ/Lp5zBBZ9U/nsUsI954XXeWKANzPlLq3ozwB Cm7AZTNm60Fn5T1RvF+4a4pq4muAIYdNJrRBNztiMncUo40hZNRB79ZHaZyUh8QfnXjz IFV0S3b6iLw3GCY4QQPDQgJqNanNR7wubzNP0= MIME-Version: 1.0 Received: by 10.142.202.16 with SMTP id z16mr331739wff.131.1275061469029; Fri, 28 May 2010 08:44:29 -0700 (PDT) Received: by 10.142.194.4 with HTTP; Fri, 28 May 2010 08:44:28 -0700 (PDT) In-Reply-To: <1275059495-sup-4074@alvh.no-ip.org> References: <1275059495-sup-4074@alvh.no-ip.org> Date: Fri, 28 May 2010 09:44:28 -0600 Message-ID: Subject: Re: Extending Regular Expression bounds limit of 255. From: Brent DeSpain To: alvherre Cc: Andrej , pgsql-sql Content-Type: multipart/alternative; boundary=000e0cd32cb8eda4ba0487a961db X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=-5 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201005/139 X-Sequence-Number: 34187 --000e0cd32cb8eda4ba0487a961db Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Yep. That is what I was looking at this morning. It is probably too late in this release of our project to make this change. Thanks for the help. Brent DeSpain Schweitzer Engineering Laboratories, Inc. On Fri, May 28, 2010 at 9:14 AM, alvherre wrote= : > Excerpts from Brent DeSpain's message of jue may 27 18:55:55 -0400 2010: > > It looks like most of our tools are using the Perl version of regular > > expressions with an upper limit of a bound being 32766. Is there any w= ay > to > > change this in PG? Or can I change from POSIX to Perl? > > See regcomp.c; you'll have to recompile. The interesting constant is > DUPMAX (defined in regguts.h as per POSIX), but note that there's > arithmetic in repeat() with those values. I wouldn't recommend doing > any of this unless you have time to figure out whether the algorithms > are efficient for larger values though. > > -- > =C1lvaro Herrera > The PostgreSQL Company - Command Prompt, Inc. > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > --000e0cd32cb8eda4ba0487a961db Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Yep.=A0 That is what I was looking at this morning.=A0 It is probably too l= ate in this release of our project to make this change.

Thanks for t= he help.

Brent DeSpain
Schweitzer Engineering Labor= atories, Inc.


On Fri, May 28, 2010 at 9:14 AM, alvherr= e <alvhe= rre@commandprompt.com> wrote:
Excerpts from Brent DeSpain's message of jue may 27 18:55:55 -0400 2010= :
> It looks like most of our tools are using the Perl v= ersion of regular
> expressions with an upper limit of a bound being 32766. =A0Is there an= y way to
> change this in PG? =A0Or can I change from POSIX to Perl?

See regcomp.c; you'll have to recompile. =A0The interesting const= ant is
DUPMAX (defined in regguts.h as per POSIX), but note that there's
arithmetic in repeat() with those values. =A0I wouldn't recommend doing=
any of this unless you have time to figure out whether the algorithms
are efficient for larger values though.

--
=C1lvaro Herrera <alvherre= @commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

--000e0cd32cb8eda4ba0487a961db-- From jasen@xnet.co.nz Sat May 29 10:28:20 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id D4A5D632904 for ; Sat, 29 May 2010 07:28:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 39052-07 for ; Sat, 29 May 2010 10:28:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtpcorp.com (smtpcorp.com [67.192.120.76]) by mail.postgresql.org (Postfix) with ESMTP id B9DB76323AE for ; Sat, 29 May 2010 07:28:12 -0300 (ADT) DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=smtpcorp.com; s=main; h=Content-Transfer-Encoding:Content-Type:Mime-Version:References:Message-ID:Date:Subject:From:To; bh=PdfI8VnZn3PUz2uphXXZryD2oDOPy60W2AvXx3eUtUI=; b=K28Wrp3yHEs5jPeCQki6uAsk1VMxhh1cYg8MEbCz89+gtOtR/G4uccNMYHN/OMjeJukw/SSnKDWyJYMA4LDHIa49uouBAILFQYfFH6YJvH3bSQiYR4mV4jWdTEpp4Y6g; Received: from ip-118-90-141-130.xdsl.xnet.co.nz ([118.90.141.130] helo=gonzo) by smtpcorp.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.70) id 1OIJH0-00019I-TH; mid 144 for pgsql-sql@postgresql.org; Sat, 29 May 2010 10:27:47 +0000 Received: from news by gonzo with local (Exim 4.69) (envelope-from ) id 1OIJGp-0001Hv-N8 for pgsql-sql@postgresql.org; Sat, 29 May 2010 22:27:59 +1200 To: pgsql-sql@postgresql.org Path: not-for-mail From: Jasen Betts Newsgroups: gmane.comp.db.postgresql.sql Subject: Re: Extending Regular Expression bounds limit of 255. Date: 29 May 2010 10:27:59 GMT Organization: Dis (not Dat) Organisation Lines: 13 Message-ID: References: NNTP-Posting-Host: localhost Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: reversiblemaps.ath.cx 1275128879 4617 127.0.0.1 (29 May 2010 10:27:59 GMT) X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W; (T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q; 8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^ User-Agent: slrn/pre1.0.0-2 (Linux) X-Smtpcorp-Track: 3521158.1.29159718 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201005/141 X-Sequence-Number: 34189 On 2010-05-27, Brent DeSpain wrote: > --00504502c13812967604879b4ba3 > Content-Type: text/plain; charset=ISO-8859-1 > > It looks like most of our tools are using the Perl version of regular > expressions with an upper limit of a bound being 32766. Is there any way to > change this in PG? Or can I change from POSIX to Perl? perhaps you can do something in pl-perl? posix regular expressions are different to perl regular expressions in several ways. From tim@tim-landscheidt.de Sat May 29 18:57:13 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 1DEF7632FDB for ; Sat, 29 May 2010 15:57:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 73174-06 for ; Sat, 29 May 2010 18:57:04 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by mail.postgresql.org (Postfix) with ESMTP id 919F6632F51 for ; Sat, 29 May 2010 15:57:04 -0300 (ADT) Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1OIRDP-0002qt-5c for pgsql-sql@postgresql.org; Sat, 29 May 2010 20:56:59 +0200 Received: from e177127132.adsl.alicedsl.de ([85.177.127.132]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 29 May 2010 20:56:59 +0200 Received: from tim by e177127132.adsl.alicedsl.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 29 May 2010 20:56:59 +0200 X-Injected-Via-Gmane: http://gmane.org/ Mail-Followup-To: pgsql-sql@postgresql.org To: pgsql-sql@postgresql.org connect(): No such file or directory From: Tim Landscheidt Subject: Re: Extending Regular Expression bounds limit of 255. Date: Sat, 29 May 2010 18:56:49 +0000 Organization: Lines: 18 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: e177127132.adsl.alicedsl.de Mail-Copies-To: never User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux) Cancel-Lock: sha1:cV9CJOyOPES5qOwyf9jRT0pJzLo= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-5 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/142 X-Sequence-Number: 34190 Jasen Betts wrote: >> It looks like most of our tools are using the Perl version of regular >> expressions with an upper limit of a bound being 32766. Is there any way to >> change this in PG? Or can I change from POSIX to Perl? > perhaps you can do something in pl-perl? > posix regular expressions are different to perl regular expressions in > several ways. Another last resort possibility would of course be to "pre- compile" the regular expressions from "A{2000}" to "A{255}A{255}A{255}A{255}A{255}A{255}A{255}A{215}" (with the headaches of "A{1000,2000}" left as an exercise to the read- er :-)). Tim From jasen@xnet.co.nz Sun May 30 10:38:26 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id D9DC76323B8 for ; Sun, 30 May 2010 07:38:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 46857-10 for ; Sun, 30 May 2010 10:38:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtpcorp.com (smtpcorp.com [67.192.120.76]) by mail.postgresql.org (Postfix) with ESMTP id 1E13C635189 for ; Sun, 30 May 2010 07:38:18 -0300 (ADT) DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=smtpcorp.com; s=main; h=Content-Transfer-Encoding:Content-Type:Mime-Version:References:Message-ID:Date:Subject:From:To; bh=+msT+K2L5D3JA5tX6kPDuJ3EjbVH3pNBKr7yytWaTNs=; b=IGuSTKuLO5q1QErsx4EEinRUzfzcQau0dh3fTlYq4TlN22yJ3gEEYiGOhwpGBp8bvHX5AYVXrxv0nvDzZWvgzAdFL5nAeah4kcTGE4LFWmPrKjIvumaPmmcKIVXBQOeo; Received: from ip-118-90-128-248.xdsl.xnet.co.nz ([118.90.128.248] helo=gonzo) by smtpcorp.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.70) id 1OIfuK-0004zZ-1O; mid 144 for pgsql-sql@postgresql.org; Sun, 30 May 2010 10:37:52 +0000 Received: from news by gonzo with local (Exim 4.69) (envelope-from ) id 1OIfu9-0001Yn-66 for pgsql-sql@postgresql.org; Sun, 30 May 2010 22:38:05 +1200 To: pgsql-sql@postgresql.org Path: not-for-mail From: Jasen Betts Newsgroups: gmane.comp.db.postgresql.sql Subject: Re: Extending Regular Expression bounds limit of 255. Date: 30 May 2010 10:37:59 GMT Organization: Dis (not Dat) Organisation Lines: 35 Message-ID: References: NNTP-Posting-Host: localhost Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: reversiblemaps.ath.cx 1275215879 5999 127.0.0.1 (30 May 2010 10:37:59 GMT) X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W; (T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q; 8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^ User-Agent: slrn/pre1.0.0-2 (Linux) X-Smtpcorp-Track: 3547530.1.45951665 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201005/143 X-Sequence-Number: 34191 On 2010-05-29, Tim Landscheidt wrote: > Jasen Betts wrote: > >>> It looks like most of our tools are using the Perl version of regular >>> expressions with an upper limit of a bound being 32766. Is there any way to >>> change this in PG? Or can I change from POSIX to Perl? > >> perhaps you can do something in pl-perl? > >> posix regular expressions are different to perl regular expressions in >> several ways. > > Another last resort possibility would of course be to "pre- > compile" the regular expressions from "A{2000}" to > "A{255}A{255}A{255}A{255}A{255}A{255}A{255}A{215}" (A{200}){10} might work better. > (with the headaches of "A{1000,2000}" left as an exercise to the read- > er :-)). easy enoungh to write, but probably easy to write an expression with factorial complexity too, but this one should work, having at worst two ways of matching any string. (A{200}){5,9}A{0,200} but (A{5,10}){200} is asking for trouble.