use of dblink_build_sql_insert() induces a server crash

From: Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: use of dblink_build_sql_insert() induces a server crash
Date: 2010-02-03 12:49:33
Message-ID: 460abcb11002030449q873b784kd8a0f1c0a7520ee1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
dblink.patch text/x-diff 603 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2010-02-03 13:41:36 Re: Add on_trusted_init and on_untrusted_init to plperl UPDATED [PATCH]
Previous Message Teodor Sigaev 2010-02-03 12:14:48 Re: [CFReview] Red-Black Tree