Re: [HACKERS] Cluster wide option to control symbol case folding - Mailing list pgsql-hackers

From Lewis, Ian \(Microstar Laboratories\)
Subject Re: [HACKERS] Cluster wide option to control symbol case folding
Date
Msg-id ACF85C502E55A143AB9F4ECFE960660A172838@mailserver2.local.mstarlabs.com
Whole thread Raw
In response to [HACKERS] Cluster wide option to control symbol case folding  ("Lewis, Ian \(Microstar Laboratories\)" <ilewis@mstarlabs.com>)
List pgsql-hackers
Robert Haas [mailto:robertmhaas@gmail.com] wrote:
>> Where you get into trouble there is that you might run CREATE
EXTENSION
>> from that session

Yes. I can see this problem. And, while I can imagine resolving it with
context belonging to the extension, separate from the current session's
context, any resolution gets to be pretty complex. Probably complex
enough that the resolution is worse than living with the problem as part
of the cost of the feature. Which means, it remains one of the arguments
against it.

>> Again, I'm not trying to rain down fire and brimstone
>> on your idea here and I clearly see the utility of it.

I do not feel this at all (though, since this is e-mail, it is helpful
that you state it explicitly). And, I have not felt like this was the
case at any point in these discussions. I have consistently received
thoughtful and remarkably good responses containing solid points.

While I did not recognize all the impacts, and I probably still do not,
I never thought this was a trivial issue with no arguments against it
(not least, that what I was asking for is not standard compliant). Every
modal behavior of any sort in any software adds pain. At the very least
it increases the regression testing burden. And, this is a mode with
pretty fundamental impact. It has to be worth a lot to somebody to be
worth having. And, of course, it also has to work.

Ian Lewis (www.mstarlabs.com)




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] ALTER TABLE parent SET WITHOUT OIDS and the oid column
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Odd behavior with PG_TRY