Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Aleksey TsalolikhinDate: 2011-07-14 18:24:52
Subject: Re: BUG #6117: psql -c does not work as expected. a documentation bug? a program bug?
Previous:From: Tom LaneDate: 2011-07-14 15:34:54
Subject: Re: BUG #6117: psql -c does not work as expected. a documentation bug? a program bug?

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