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

From Rushabh Lathia
Subject use of dblink_build_sql_insert() induces a server crash
Date
Msg-id 460abcb11002030449q873b784kd8a0f1c0a7520ee1@mail.gmail.com
Whole thread Raw
Responses Re: use of dblink_build_sql_insert() induces a server crash
Re: use of dblink_build_sql_insert() induces a server crash
List pgsql-hackers
Hi All,

Testcase:

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
    This probably means the server terminated abnormally
    before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Version: Latest

Description:  The dblink_build_sql_insert()/get_tuple_of_interest functions is not taking care number of attributes in the target.

PFA patch to fix the same.

Thanks,
Rushabh Lathia
(www.EnterpriseDB.com)
Attachment

pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: [CFReview] Red-Black Tree
Next
From: Chris Campbell
Date:
Subject: Recent vendor SSL renegotiation patches break PostgreSQL