| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Gavin Flower <gavinflower(at)archidevsys(dot)co(dot)nz>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Spurious errors relating to escaped single quotes |
| Date: | 2011-07-14 19:14:17 |
| Message-ID: | 7689.1310670857@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Alvaro Herrera <alvherre(at)commandprompt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Flower | 2011-07-14 20:00:45 | Re: Spurious errors relating to escaped single quotes |
| Previous Message | Aleksey Tsalolikhin | 2011-07-14 18:24:52 | Re: BUG #6117: psql -c does not work as expected. a documentation bug? a program bug? |