Could regexp_matches be immutable?
in [PgSql]
|
From: Tom Lane on 14 Oct 2009 22:20 Andrew Dunstan <andrew(a)dunslane.net> writes: > They are probably quite open to changing it, but IIRC it is a setting > imposed by OpenACS, which is what they are based on. I seem to recall having asked this before ... but does OpenACS even know what they're doing here? The difference between ERE mode and ARE mode is awfully slight. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Andrew Dunstan on 14 Oct 2009 23:51 Tom Lane wrote: > Andrew Dunstan <andrew(a)dunslane.net> writes: > >> They are probably quite open to changing it, but IIRC it is a setting >> imposed by OpenACS, which is what they are based on. >> > > I seem to recall having asked this before ... but does OpenACS even > know what they're doing here? The difference between ERE mode and ARE > mode is awfully slight. > That's not the worst of it :-( See <http://openacs.org/xowiki/How_to_install_in_Postgres_8.x> cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: David Fetter on 15 Oct 2009 00:13 On Wed, Oct 14, 2009 at 11:51:13PM -0400, Andrew Dunstan wrote: > > > Tom Lane wrote: >> Andrew Dunstan <andrew(a)dunslane.net> writes: >> >>> They are probably quite open to changing it, but IIRC it is a >>> setting imposed by OpenACS, which is what they are based on. >> >> I seem to recall having asked this before ... but does OpenACS even >> know what they're doing here? The difference between ERE mode and >> ARE mode is awfully slight. > > That's not the worst of it :-( See > <http://openacs.org/xowiki/How_to_install_in_Postgres_8.x> This just illustrates the fact that at least as far as PostgreSQL is concerned, OpenACS is a dead project. It's been at least 3 major versions since they even attempted to keep compatible with PostgreSQL. OpenACS could be revived as a PostgreSQL-supporting piece of software, and that might be a good thing. It would entail adjusting OpenACS to the things PostgreSQL has changed rather than the reverse. Cheers, David. -- David Fetter <david(a)fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter(a)gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Tom Lane on 15 Oct 2009 01:04 David Fetter <david(a)fetter.org> writes: > On Wed, Oct 14, 2009 at 11:51:13PM -0400, Andrew Dunstan wrote: >> That's not the worst of it :-( See >> <http://openacs.org/xowiki/How_to_install_in_Postgres_8.x> > This just illustrates the fact that at least as far as PostgreSQL is > concerned, OpenACS is a dead project. It's been at least 3 major > versions since they even attempted to keep compatible with PostgreSQL. That seems pretty harsh, considering that there's plenty of discussion of how to use OpenACS with PG on their website. What it looks like to me is that the recommendation about regex_flavor might be just cargo-cult programming. Somebody had some trouble with an updated PG version, turned on every backwards-compatibility option he could find, and when it worked he didn't inquire too closely into which settings were actually important. And ever since then that's been the received wisdom about how to make OpenACS run with Postgres. It would be interesting to try turning off these options one at a time to see which ones do matter. (I'd bet lunch that the one about add_missing_from is bogus, too, or could easily be made so. mysql isn't forgiving about missing FROM items, so it's hard to believe that they have a lot of such things no matter how little they care about Postgres.) regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Josh Berkus on 15 Oct 2009 13:22
> (I'd bet lunch that the one about add_missing_from is bogus, too, > or could easily be made so. mysql isn't forgiving about missing > FROM items, so it's hard to believe that they have a lot of such > things no matter how little they care about Postgres.) OpenACS does the old-style DELETEs without a subselect, so they rely on add-missing-from for that. I had to debug this for another user. --Josh Berkus -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |