Re: Spurious errors relating to escaped single quotes

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Gavin Flower <gavinflower(at)archidevsys(dot)co(dot)nz>
Cc: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Spurious errors relating to escaped single quotes
Date: 2011-07-14 16:45:08
Message-ID: 1310661849-sup-6899@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Excerpts from Gavin Flower's message of jue jul 14 07:45:00 -0400 2011:
> Hi,
>
> 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.

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next 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?
Previous Message Tom Lane 2011-07-14 15:34:54 Re: BUG #6117: psql -c does not work as expected. a documentation bug? a program bug?