Re: Spurious errors relating to escaped single quotes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Spurious errors relating to escaped single quotes
Дата
Msg-id 7689.1310670857@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Spurious errors relating to escaped single quotes  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Spurious errors relating to escaped single quotes  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Список 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 по дате отправления:

Предыдущее
От: Aleksey Tsalolikhin
Дата:
Сообщение: Re: BUG #6117: psql -c does not work as expected. a documentation bug? a program bug?
Следующее
От: Gavin Flower
Дата:
Сообщение: Re: Spurious errors relating to escaped single quotes