Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 5834B63280E for ; Thu, 18 Feb 2010 11:32:32 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 28407-06 for ; Thu, 18 Feb 2010 15:32:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 650D56325E3 for ; Thu, 18 Feb 2010 11:32:21 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o1IFWHrE020228; Thu, 18 Feb 2010 10:32:17 -0500 (EST) To: zkn cc: pgsql-sql@postgresql.org Subject: Re: Problem with batch insert In-reply-to: <1077F011-859B-4AE5-AE95-65B45F775DE6@abv.bg> References: <1077F011-859B-4AE5-AE95-65B45F775DE6@abv.bg> Comments: In-reply-to zkn message dated "Thu, 18 Feb 2010 14:53:07 +0200" Date: Thu, 18 Feb 2010 10:32:17 -0500 Message-ID: <20227.1266507137@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.535 tagged_above=-10 required=5 tests=AWL=-0.795, BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 201002/72 X-Sequence-Number: 33671 zkn writes: > I have a weird problem with batch insert. It works fine on my development machine but when I upload to the server it fails. Here is the log: > DEBUG [http-8443-2] - {conn-100123} Preparing Statement: insert into target_filters_sections (filter_id, section_id) values (?, ?) , (?, ?) > DEBUG [http-8443-2] - Unable to translate SQLException with SQL state '42601', error code '0, will now try the fallback translator 42601 is a syntax error, although I think you ought to complain to somebody about the fact that your tools don't show you the actual server error message. > Postgre version on the server 8.1 on development 8.3 8.1 does not support multiple rows in a VALUES construct. regards, tom lane