--00032555a2d2774d050475756526
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Hello All,
I have a prorietary ETL program, reading from postgres 8.4.1 via psqlODBC
08.04.0100, all on Windows XP.
SELECT query on a large view fails with series of errors.
ODBC driver log: http://pgsql.privatepaste.com/5e1Hitpcm7 - fragments
follow.
any hints?
[226.037]CONN ERROR: func=3DCC_send_query, desc=3D'', errnum=3D109, errmsg=
=3D'Out of
memory while reading tuples.'
....
[226.054]STATEMENT ERROR: func=3DSC_execute, desc=3D'(null)', errnum=3D7,
errmsg=3D'Error while executing the query'
....
[226.074]CONN ERROR: func=3DSC_execute, desc=3D'(null)', errnum=3D109, errm=
sg=3D'Out
of memory while reading tuples.'
....
[226.082]STATEMENT ERROR: func=3DPGAPI_NumResultCols, desc=3D'', errnum=3D1=
,
errmsg=3D'No query has been executed with that handle'
--
Filip Rembia=C5=82kowski
JID,mailto:filip.rembialkowski [at] gmail.com
http://filip.rembialkowski.net/
--00032555a2d2774d050475756526
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Hello All,<br><br><br>I have a prorietary ETL program, reading from postgre=
s 8.4.1 via psqlODBC 08.04.0100, all on Windows XP.<br>SELECT query on a la=
rge view fails with series of errors.<br>
<br>ODBC driver log: <a href=3D"http://pgsql.privatepaste.com/5e1Hitpcm7">h=
ttp://pgsql.privatepaste.com/5e1Hitpcm7</a> - fragments follow.<br><br>any =
hints?<br><br><br>[226.037]CONN ERROR: func=3DCC_send_query, desc=3D'&#=
39;, errnum=3D109, errmsg=3D'Out of memory while reading tuples.'<b=
r>
....<br>[226.054]STATEMENT ERROR: func=3DSC_execute, desc=3D'(null)'=
, errnum=3D7, errmsg=3D'Error while executing the query'<br>...<br>=
[226.074]CONN ERROR: func=3DSC_execute, desc=3D'(null)', errnum=3D1=
09, errmsg=3D'Out of memory while reading tuples.'<br>
....<br>[226.082]STATEMENT ERROR: func=3DPGAPI_NumResultCols, desc=3D'&#=
39;, errnum=3D1, errmsg=3D'No query has been executed with that handle&=
#39;<br><br><br>-- <br>Filip Rembia=C5=82kowski<br>JID,mailto:<a href=3D"ma=
ilto:filip.rembialkowski [at] gmail.com">filip.rembialkowski [at] gmai l.com</a><br>
<a href=3D"http://filip.rembialkowski.net/">http://filip.rembialkowski.net/=
</a><br>
--00032555a2d2774d050475756526--
