Re: use of dblink_build_sql_insert() induces a server crash - Mailing list pgsql-hackers

From Joe Conway
Subject Re: use of dblink_build_sql_insert() induces a server crash
Date
Msg-id 4B69BB90.5050607@joeconway.com
Whole thread Raw
In response to use of dblink_build_sql_insert() induces a server crash  (Rushabh Lathia <rushabh.lathia@gmail.com>)
Responses Re: use of dblink_build_sql_insert() induces a server crash
List 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

Attachment

pgsql-hackers by date:

Previous
From: Aidan Van Dyk
Date:
Subject: Re: PG 9.0 and standard_conforming_strings
Next
From: Tom Lane
Date:
Subject: Re: use of dblink_build_sql_insert() induces a server crash