Re: Large queries - again...

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 the elog() mention.  I don't see
where we added a call to elog() in the past day.  I only see two
mentions of elog in the code, both it dllist.c.  They don't use elog()
if you define FRONTEND.  Please do -DFRONTEND on the compile line.  I
think this will give you a good library binary.

Let us know how the new code works.  The most recent patch I just
applied was tested by a user and it worked well for him.  Nice to have
this resolved.  I can mark this TODO item as done:
* -Fix libpq to properly handle socket failures under native MS  Win32 [libpq]



> > "Steve Howe" <howe@carcass.dhs.org> 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 --- the "errno=0" bogosity isn't helping.
> > As Bruce mentioned, we did just commit a patch that #defines errno
> > as WSAGetLastError() on WIN32, so that you can get at least something
> > useful about socket errors.  I'd suggest pulling the current CVS sources
> > (or a nightly snapshot tarball dated after today) and building libpq
> > from that.  Then maybe we can learn more.
> Unhappyly, there are unresolved externals and it won't build...
> I'll try to fix it.
> The log follows right below...
> 
> Best regards,
> Steve Howe
> 
> ----------------------------------------------------------------------------
> ----------
> Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
> Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
> 
>         cd include
>         if not exist config.h copy config.h.win32 config.h
>         cd ..
>         cd interfaces\libpq
>         nmake /f win32.mak
> 
> Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
> Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
> 
>         link.exe @C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\nma01588.
>    Creating library .\Release\libpqdll.lib and object .\Release\libpqdll.exp
> libpq.lib(fe-exec.obj) : error LNK2001: unresolved external symbol _snprintf
> libpq.lib(fe-misc.obj) : error LNK2001: unresolved external symbol _snprintf
> libpq.lib(fe-auth.obj) : error LNK2001: unresolved external symbol _snprintf
> libpq.lib(dllist.obj) : error LNK2001: unresolved external symbol _elog
> .\Release\libpq.dll : fatal error LNK1120: 2 unresolved externals
> NMAKE : fatal error U1077: 'link.exe' : return code '0x460'
> Stop.
> NMAKE : fatal error U1077: '"C:\Program Files\Microsoft Visual
> Studio\VC98\bin\NMAKE.EXE"' : return
> code '0x2'
> Stop.
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://www.postgresql.org/search.mpl
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026