Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 1D06463291A
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 18 Feb 2010 12:06:02 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 87869-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 18 Feb 2010 16:05:51 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp-out.abv.bg (smtp-out.abv.bg [194.153.145.99])
	by mail.postgresql.org (Postfix) with ESMTP id 355F1632903
	for <pgsql-sql@postgresql.org>; Thu, 18 Feb 2010 12:05:50 -0400 (AST)
Received: from smtp.abv.bg (m2.ni.bg [192.168.151.127])
	by smtp-out.abv.bg (Postfix) with ESMTP id 2ABE514EC60;
	Thu, 18 Feb 2010 18:03:38 +0200 (EET)
DomainKey-Signature: a=rsa-sha1; s=smtp-out; d=abv.bg; c=simple; q=dns;
	b=NzZOOhN48nCDt4c9LS5MU3inmCpKcUKJWARmsmgFxFSPQb8d58ix2lbpiPNcGO76H
	OJMWCwnIK/Wg1LBoT5nbD5b2ZXY12bT2IpI0OlXgXSyeS/0S7mMiCnVci0BLNHPNyuB
	Ytw/NnHsSpTdSC1/LdoLW6WssvwZMst+8juW3KA=
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=abv.bg; s=smtp-out;
	t=1266509018; bh=Ip/GK+al/KSEI25s6O1/69EYypRPyKl7tGmSGfg2JV8=;
	h=Subject:Mime-Version:Content-Type:From:In-Reply-To:Date:Cc:
	Message-Id:References:To:DKIM; b=joPC3cy2CxOpShCScVkZj4toJ/rlaLu8g
	r+jvzCurez16hbFt3jTAqSjhfRLjqEPPwLoMSSXtUaI9PS70Se+FejFpNR2s8g2wF0g
	YRH6OE32pwWIh9RutDjt2AJgKeMhEwwMiLGul2lz3YKxiXYdSaSkBo5o9tgxEMn3ur9
	rWmk=
Received: from Unknown (HELO [192.168.180.4]) (78.90.12.216)
	(smtp-auth username iuzkan@abv.bg, mechanism plain)
	by smtp.abv.bg (qpsmtpd/0.82) with ESMTPA;
	Thu, 18 Feb 2010 18:05:49 +0200
Subject: Re: Problem with batch insert 
Mime-Version: 1.0 (Apple Message framework v1077)
Content-Type: multipart/alternative; boundary=Apple-Mail-1-439139021
From: zkn <zkn@abv.bg>
In-Reply-To: <20227.1266507137@sss.pgh.pa.us>
Date: Thu, 18 Feb 2010 18:05:47 +0200
Cc: pgsql-sql@postgresql.org
Message-Id: <B4038102-1B3F-45E5-8C9E-9C2818815419@abv.bg>
References: <1077F011-859B-4AE5-AE95-65B45F775DE6@abv.bg>
	<20227.1266507137@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
X-Mailer: Apple Mail (2.1077)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.739 tagged_above=-10 required=5
	tests=BAYES_20=-0.74, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201002/73
X-Sequence-Number: 33672


--Apple-Mail-1-439139021
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii


On 18.02.2010, at 17:32, Tom Lane wrote:

> zkn <zkn@abv.bg> 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:
>=20
>> DEBUG [http-8443-2] - {conn-100123} Preparing Statement: insert into =
target_filters_sections (filter_id, section_id) values (?, ?) , (?, ?)=20=

>=20
>> DEBUG [http-8443-2] - Unable to translate SQLException with SQL state =
'42601', error code '0, will now try the fallback translator
>=20
> 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.
>=20
>> Postgre version on the server 8.1 on development 8.3
>=20
> 8.1 does not support multiple rows in a VALUES construct.

Yes, it was the postgre version.

>=20
> 			regards, tom lane
>=20
> --=20
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>=20


--Apple-Mail-1-439139021
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=us-ascii

<html><head></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space; =
"><br><div><div>On 18.02.2010, at 17:32, Tom Lane wrote:</div><br =
class=3D"Apple-interchange-newline"><blockquote type=3D"cite"><div>zkn =
&lt;<a href=3D"mailto:zkn@abv.bg">zkn@abv.bg</a>&gt; =
writes:<br><blockquote type=3D"cite">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:<br></blockquote><br><blockquote =
type=3D"cite">DEBUG [http-8443-2] - {conn-100123} Preparing Statement: =
insert into target_filters_sections (filter_id, section_id) values (?, =
?) , (?, ?) <br></blockquote><br><blockquote type=3D"cite">DEBUG =
[http-8443-2] - Unable to translate SQLException with SQL state '42601', =
error code '0, will now try the fallback =
translator<br></blockquote><br>42601 is a syntax error, although I think =
you ought to complain to<br>somebody about the fact that your tools =
don't show you the actual server<br>error =
message.<br></div></blockquote><blockquote type=3D"cite"><div><font =
class=3D"Apple-style-span" color=3D"#000000"><br></font><blockquote =
type=3D"cite">Postgre version on the server 8.1 on development =
8.3<br></blockquote><br>8.1 does not support multiple rows in a VALUES =
construct.<br></div></blockquote><div><br></div><div>Yes, it was the =
postgre version.</div><br><blockquote type=3D"cite"><div><br><span =
class=3D"Apple-tab-span" style=3D"white-space:pre">	</span><span =
class=3D"Apple-tab-span" style=3D"white-space:pre">	</span><span =
class=3D"Apple-tab-span" style=3D"white-space:pre">	</span>regards, =
tom lane<br><br>-- <br>Sent via pgsql-sql mailing list (<a =
href=3D"mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br>=
To make changes to your subscription:<br><a =
href=3D"http://www.postgresql.org/mailpref/pgsql-sql">http://www.postgresq=
l.org/mailpref/pgsql-sql</a><br><br></div></blockquote></div><br></body></=
html>=

--Apple-Mail-1-439139021--