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: "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: "Greg Sabino Mullane" <greg(at)endpoint(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PG 9.0 and standard_conforming_strings
Date: 2010-02-03 18:37:14
Message-ID: 4B696DFA020000250002EEDC@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackers
Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
 
> What harm is being done by the status quo?  What benefit do
> we get out of changing the default?
 
I really think that the biggest harm is that people trying to
convert to PostgreSQL, or testing PostgreSQL with their
applications, can get bad behavior from use of standard string
literals.  If they post to a list and we point out the setting,
that'll probably be the end of the trouble -- and I have seen a few
such posts.  Interestingly, the frequency of such posts dropped off
after 8.2 was released with the GUC to configure it, which suggests
that people are often reading documentation before making the
attempt or at least doing web searches about the problem and fixing
it without a post to the community.
 
I do think we might be well-served to have such issues as this and
the "it's not a character string literal, it's a literal of UNKNOWN
type" covered in a page which is prominent enough to be likely to be
read by those considering migration or compatibility testing.  I'm
not sure exactly where that would be, unless it's a couple more FAQ
entries -- but a "compatibility and migration" page might be worth
creating, with a reasonably prominent link from the home page.
 
-Kevin

In response to

pgsql-hackers by date

Next:From: Rod TaylorDate: 2010-02-03 18:37:28
Subject: Re: PG 9.0 and standard_conforming_strings
Previous:From: Alvaro HerreraDate: 2010-02-03 18:36:13
Subject: Re: PG 9.0 and standard_conforming_strings

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