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(at)carcass(dot)dhs(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026