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

Re: use of dblink_build_sql_insert() induces a server crash

From: Joe Conway <mail(at)joeconway(dot)com>
To: Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: use of dblink_build_sql_insert() induces a server crash
Date: 2010-02-03 18:08:16
Message-ID: 4B69BB90.5050607@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 02/03/2010 04:49 AM, Rushabh Lathia wrote:
> 
> create table foo (a  int );
> postgres=# SELECT dblink_build_sql_insert('foo','1 2',2,'{\"0\",
> \"a\"}','{\"99\", \"xyz\"}');
> HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
> server closed the connection unexpectedly

The problem exists with all three dblink_build_sql_* functions. Here is
a more complete patch. If there are no objections I'll apply this to
HEAD and look at back-patching -- these functions have hardly been
touched since inception.

Joe

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-02-03 18:18:00
Subject: Re: use of dblink_build_sql_insert() induces a server crash
Previous:From: Aidan Van DykDate: 2010-02-03 18:02:38
Subject: Re: PG 9.0 and standard_conforming_strings

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