On Wed, Aug 24, 2005 at 12:26:21AM -0400, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > Is the intention that standard_conforming_strings will always be > > read-only? > > For the moment it's read-only false; the long-term goal is that it will > be read-only true. In between we will have a release or three where it > is modifiable to some extent. I personally think it would be a *bad* > idea if it were a mere USERSET variable --- we learned from the > autocommit fiasco that changing fundamental semantics on a whim does > not work. But there will need to be some way to alter it for testing > purposes during the interregnum.
The 'autocommit fiasco' isn't ringing a bell right now, so I'll take your word for it. :) Bruce, can you add some info about this to http://candle.pha.pa.us/cgi-bin/pgescape ? I intend to link to that when I submit a patch to the release notes that links to more info on the individual items. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match