From: | "Eduardo Stern" <eduardo(at)stern(dot)com(dot)br> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Large queries - again... |
Date: | 2001-07-20 14:34:41 |
Message-ID: | 9j9fe3$im1$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Well, I tested the query you sent, and I got these results accessing the
data:
1) libpq from Windows (freshly compiled from 7.1.2 sources): Error:
pqReadData() -- read() failed: errno=0
No error
2) ODBC from Windows: It works ok.
Steve Howe <howe(at)carcass(dot)dhs(dot)org> escreveu nas notcias de
mensagem:9j8jce$ddo$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> Hello all,
>
> I've tried again sending large queries using libpq on Windows
> environment, without success.
> I downloaded the PostgreSQL v7.12 sources, compiled libpq.dll
using
> Microsoft's Visual C++ 6.0, and tried sending a large query.
> The problem is, when the query is > 8192 large, a NULL pointer is
> returned from PQexec().
> I have tried using ZDE (http://www.zeoslib.org) which I helped
> develop, and pgAccess. ZDE is based on the Zeos Database Objects library,
> which provides full access to PostgreSQL to Borland Delphi and Borland C++
> Builder compilers.
> Could anyone please try this query:
> ftp://carcass.dhs.org/pub/test.zip on windows (using libpq) and confirm it
> suceed ? This archive contains a test.sql source, which will create a dumb
> table with a text filed and then try to insert in it a large data (>8192
> bytes) on it, and the libpq.dll I just compiled, for who want a fresh
libpq
> (it's virus free, don't worry... ). All my current PostgreSQL driver
> implementation is depending on this. I'm sure the libpq will fail, unless
> something very weird is happening in here... :)
> Other friends have confirmed this behaviour.
> I tried to look at the libpq sources to find out where's the
error,
> but I think it will take much less time to who develops it...
>
> Best Regards,
> Steve Howe
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB | 2001-07-20 14:45:19 | AW: OID wraparound (was Re: pg_depend) |
Previous Message | Bruce Momjian | 2001-07-20 14:27:00 | Added TODO item |