Re: [HACKERS] Large queries - again...

2001-07-23 Thread Steve Howe
> Tom Lane wrote: > > "Steve Howe" <[EMAIL PROTECTED]> writes: > > > ..\..\backend\lib\dllist.c(20) : fatal error C1083: Cannot open include > > > file: 'sysexits.h': No such file or directory > > > > Jan added that recently. I was wondering if it was portable or not ... > > looks like now we kno

Re: [HACKERS] Large queries - again...

2001-07-23 Thread Jan Wieck
Tom Lane wrote: > "Steve Howe" <[EMAIL PROTECTED]> writes: > > ..\..\backend\lib\dllist.c(20) : fatal error C1083: Cannot open include > > file: 'sysexits.h': No such file or directory > > Jan added that recently. I was wondering if it was portable or not ... > looks like now we know :-(. Gr

Re: [HACKERS] Large queries - again...

2001-07-21 Thread Bruce Momjian
> > OK, I just applied a patch to add the final fixes to Win32 libpq. > > Please try the CVS or later snapshot to see how it works. The patch > > suggested adding > > > > #define snprintf _snprintf > > > > to win32.h and I have done that. There was already one there for > > vsnprintf. I am quit

Re: [HACKERS] Large queries - again...

2001-07-21 Thread Tom Lane
"Steve Howe" <[EMAIL PROTECTED]> writes: > ..\..\backend\lib\dllist.c(20) : fatal error C1083: Cannot open include > file: 'sysexits.h': No such file or directory Jan added that recently. I was wondering if it was portable or not ... looks like now we know :-(. For the moment, just take out the

Re: [HACKERS] Large queries - again...

2001-07-20 Thread Steve Howe
- Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "Steve Howe" <[EMAIL PROTECTED]> Cc: "Tom Lane" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, July 21, 2001 1:39 AM Subject: Re: [HACKERS] Large queries

Re: [HACKERS] Large queries - again...

2001-07-20 Thread Bruce Momjian
OK, I just applied a patch to add the final fixes to Win32 libpq. Please try the CVS or later snapshot to see how it works. The patch suggested adding #define snprintf _snprintf to win32.h and I have done that. There was already one there for vsnprintf. I am quite confused about th

Re: [HACKERS] Large queries - again...

2001-07-20 Thread Steve Howe
> "Steve Howe" <[EMAIL PROTECTED]> writes: > >> (Thinks for awhile...) You're not using PQsetnonblocking() are you, > >> by any chance? > > > No, I'm not. > > Drat, another perfectly good theory down the drain :-(. > > Well, we're not going to find out anymore until we discover what the > error c

Re: [HACKERS] Large queries - again...

2001-07-20 Thread Tom Lane
"Steve Howe" <[EMAIL PROTECTED]> writes: >> (Thinks for awhile...) You're not using PQsetnonblocking() are you, >> by any chance? > No, I'm not. Drat, another perfectly good theory down the drain :-(. Well, we're not going to find out anymore until we discover what the error code actually is -

Re: [HACKERS] Large queries - again...

2001-07-20 Thread Bruce Momjian
> > "As expected"? That's not what I'd expect, especially not for a > > behavior that's dependent on the size of an *outgoing* message. > It is expected, because it's the default message when a PQexec() query > returns NULL: pqReadData() will return nothing yet no error is signed. > Of course, th

Re: [HACKERS] Large queries - again...

2001-07-20 Thread Steve Howe
- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Steve Howe" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 20, 2001 5:17 PM Subject: Re: [HACKERS] Large queries - again... > "Steve Howe" <[E

Re: [HACKERS] Large queries - again...

2001-07-20 Thread Tom Lane
"Steve Howe" <[EMAIL PROTECTED]> writes: > It returns "Error: pqReadData() -- read() failed: errno=0 No error > " as expected when a nil pointer is returned. "As expected"? That's not what I'd expect, especially not for a behavior that's dependent on the size of an *outgoing* message.

Re: [HACKERS] Large queries - again...

2001-07-20 Thread Steve Howe
ROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 20, 2001 2:42 PM Subject: Re: [HACKERS] Large queries - again... > "Steve Howe" <[EMAIL PROTECTED]> writes: > > Nope, I'm 100% sure that the libpq.dll used is the one I just > > compiled. An

Re: [HACKERS] Large queries - again...

2001-07-20 Thread Tom Lane
"Steve Howe" <[EMAIL PROTECTED]> writes: > Nope, I'm 100% sure that the libpq.dll used is the one I just > compiled. And I never installed an older libpq.dll on this system. Hmph. So what is left in PQerrorMessage() after the failure? regards, tom lane -

Re: [HACKERS] Large queries - again...

2001-07-20 Thread Steve Howe
ample that proves libpq under windows has this bug ??? Best Regards, Steve Howe - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Steve Howe" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 20, 2001 12:35 PM Subject: Re: [H

Re: [HACKERS] Large queries - again...

2001-07-20 Thread Tom Lane
"Steve Howe" <[EMAIL PROTECTED]> writes: > 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(). It sure sound

[HACKERS] Large queries - again...

2001-07-20 Thread Steve Howe
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