Skip site navigation (1) Skip section navigation (2)

Re: PG 9.0 and standard_conforming_strings

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Alex Hunsaker" <badalex(at)gmail(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Bruce Momjian" <bruce(at)momjian(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PG 9.0 and standard_conforming_strings
Date: 2010-01-29 21:32:16
Message-ID: 4B62FF80020000250002ED75@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackers
Alex Hunsaker <badalex(at)gmail(dot)com> wrote:
 
> After skimming the thread Bruce linked:
>  http://archives.postgresql.org/pgsql-hackers/2009-04/msg00512.php
> 
> It certainly seems "insufficiently-thought-out".  :(
 
Just as a clarification, while the GUC was *added* in 8.1, it was
read-only with a value of 'off'.  I submitted a patch and started
using it under 8.1 in February of 2006 (because we had an urgent
need), and it officially became *settable* in 8.2.
 
I don't have strong feelings about changing the default.  Obviously,
this bites people primarily when converting to PostgreSQL -- that's
when it bit me and that's where people normally are when they post
to the lists about related issues.
 
It's not clear to me that the issues related to functions have been
thought out sufficiently; my personal feeling is that a function
should run with the setting under which it was created (as the
semantics of the literal seem as though they should be "frozen" at
that point), but that was shot down.  And then there's the issue
about EXECUTE.  If we don't have consensus on a solution to those
issues, maybe we should wait.  Those who need it who are already
using PostgreSQL already have it figured out -- it's just a bump on
the road to converting for those used to standard literals.
 
-Kevin

In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2010-01-29 22:28:55
Subject: Re: odd output in initdb
Previous:From: Bruce MomjianDate: 2010-01-29 21:24:07
Subject: Re: PG 9.0 and standard_conforming_strings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group