Re: Could regexp_matches be immutable?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Rod Taylor <rod(dot)taylor(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Could regexp_matches be immutable?
Date: 2009-10-21 09:57:45
Message-ID: 1256119065.12996.0.camel@fsopti579.F-Secure.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2009-10-20 at 20:48 -0400, Tom Lane wrote:
> So I went to see about making the changes to remove regex_flavor, and
> was astonished to find that all the regex-related functions are already
> marked immutable, and AFAICS always have been. This is clearly wrong,
> and we would have to fix it if we weren't about to remove the GUC.
> (In principle we should advise people to change the markings in existing
> databases, but given the lack of complaints it's probably not worth the
> trouble --- I doubt many applications change regex_flavor on the fly.)

Are you sure this wasn't intentional, because it breaks performance and
we doubted that many applications would change regex_flavor on the fly?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2009-10-21 10:00:08 Re: UTF8 with BOM support in psql
Previous Message Dave Page 2009-10-21 09:49:57 Re: Client application name