Re: Spurious errors relating to escaped single quotes - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Spurious errors relating to escaped single quotes
Date
Msg-id 7689.1310670857@sss.pgh.pa.us
Whole thread Raw
In response to Re: Spurious errors relating to escaped single quotes  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Spurious errors relating to escaped single quotes  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-bugs
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Gavin Flower's message of jue jul 14 07:45:00 -0400 2011:
>> Using pg 9.1beta3, I was found that running a function generated an
>> error relating to escaped single quotes, yet still produced the answer I
>> expected!

> The errors are not spurious.  The function doesn't exist now because it
> didn't get created.  What happened is that now your inserts are going
> into the parent table, not the partitions as your script intended.

Possibly a more useful answer is "your function appears to be assuming
that standard_conforming_strings is OFF.  As of 9.1 it's ON by default".

            regards, tom lane

pgsql-bugs by date:

Previous
From: Aleksey Tsalolikhin
Date:
Subject: Re: BUG #6117: psql -c does not work as expected. a documentation bug? a program bug?
Next
From: Gavin Flower
Date:
Subject: Re: Spurious errors relating to escaped single quotes