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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Attachment Content-Type Size
fix-dblink_build_sql.r0.patch text/x-patch 6.3 KB

In response to

Responses

Browse pgsql-hackers by date

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