No subject

Sun Nov 18 18:09:07 JST 2012

I have the same problem when I try it with python: (this shows better what
I mean)

>>> import pyodbc>>> conn = pyodbc.connect('DSN=PostgreSQL')>>> cursor=conn.cursor()>>> query = "INSERT INTO table foo () values (), ()">>> cursor.execute(query)<pyodbc.Cursor object at 0x7f52858e2f30>>>> conn.commit()
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
pyodbc.Error: ('HY000', 'The driver did not supply an error!')>>>
cursor.execute(query)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
pyodbc.Error: ('08S01', '[08S01] Could not send Query(connection
dead);\nCould not send Query(connection dead) (26) (SQLExecDirectW)')

Is there a way we can get around that?

This script works great when we connect to postgres without going through
pgpool.

wkr,
Bert

--e89a8ff2535c5c331404d3dfb813
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div><div>Hello, </div>We are currently migra=
ting from db2 to postgres. Our setup is quite simple: we have one tool that=
 reads (reporting service), and only 2 tools that write.=C2=A0 This means t=
hat we&#39;ll never get in the situation where we have &gt;20 connections t=
o the db at the same time. 
But because our sql statements are sometimes very complicated we have set u=
p postgres with streaming replication, and placed pgpool in front. =
</div>pgpool really works good for read-only cursors: our reporting system =
works great, and connections are send to both server. 
However we have a problem with our ETL system. From the moment it starts=
 writing data it fails. </div>I have the same problem when I try it=
 with python: (this shows better what I mean) <pre style class=3D""><cod=
e>&gt;&gt;&gt; import pyodbc
&gt;&gt;&gt; conn <s=
pan class=3D"">=3D pyodbc.<=
/span>connect(&#39;DSN=3DPostgreSQL&#39;)
&gt;&gt;&gt; cursor=3Dconn</sp=
an>.cursor=
()
&gt;&gt;&gt; query <=
span class=3D"">=3D &quot;I=
NSERT INTO table foo () values (), ()&quot;
&gt;&gt;&gt; cursor.execute</s=
pan>(query=
)
&lt;pyodbc.Cursor object at </=
span>0x7f52858e2f30&gt;<spa=
n class=3D"">
&gt;&gt;&gt; conn<sp=
an class=3D"">.commit()</sp=
an>
Traceback (most recent call=
 last):
 File &quot;&lt;stdin&gt;&quot;, line 1, in <span=
 class=3D"">&lt;module&gt;<=
/span>
pyodbc.Error: (&#39;HY000&#39;, <=
/span>&#39;The driver did not supply an error!&#39;=
)
&gt;&gt;&gt; cursor.execute</s=
pan>(query=
)
Traceback (most recent call=
 last):
 File &quot;&lt;stdin&gt;&quot;, line 1, in <span=
 class=3D"">&lt;module&gt;<=
/span>
pyodbc.Error: (&#39;08S01&#39;, <=
/span>&#39;[08S01] Could not send Query(connection dead);\=
nCould not send Query(connection dead) (26) (SQLExecDirectW)&#39;<sp=
an class=3D"">) 
 </code></pre> <div><div>Is there a way we can get around that=
? </div><div>This script works great when we connect to postgres wi=
thout going through pgpool. wkr, Bert </div></div></div>

--e89a8ff2535c5c331404d3dfb813--