Re: PQprint under Windows

Bruce Momjian wrote:
> Christoph Zwerschke wrote:
>> I tried to compile PyGreSQL under Windows.
>> Everything seems to work, except some functions which are using PQprint.
>> Whenever these functions are called, I get a Windows exception.
>> ...
>> Can anybody confirm that PQprint is or was ever running under Windows?
>> The 8.1 docu does not say that it is deprecated or not running under
>> Windows. Can it be a bug?
>
> It should work. What exception are you getting, and what line in the C
> file is it complaining about?

Here is the exception I am getting:
-------------------------------------------------------------------
pythonw.exe caused an Invalid Handle at location 7c974ed1 in module
ntdll.dll.

Registers:
eax=0021f6a0 ebx=00000000 ecx=0021f6e8 edx=7c91eb94 esi=7c38b528
edi=00000000
eip=7c974ed1 esp=0021f6a0 ebp=0021f6f0 iopl=0 nv up ei pl zr na
po nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000
efl=00000246

Call stack:
7C974ED1 ntdll.dll:7C974ED1 RtlRaiseStatus
7C95243C ntdll.dll:7C95243C RtlInitializeSListHead
7C91104B ntdll.dll:7C91104B RtlEnterCriticalSection
77C1174F msvcrt.dll:77C1174F fwrite
6311321C libpq.dll:6311321C pg_encoding_to_char
63114007 libpq.dll:63114007 pg_encoding_to_char
63114067 libpq.dll:63114067 pg_encoding_to_char
631094A2 libpq.dll:631094A2 PQprint
10003DC3 _pg.dll:10003DC3 _onexit dllcrt1.c:183
_onexit_t _onexit(
_onexit_t pfn = &0x00a7a110
-------------------------------------------------------------------

This happened when I was using the libpq.dll from the official binary
distribution of PostgreSQL 8.1.2. When I compiled libpq.dll myself to
find out more, amazingly everything worked fine, there was no exception.
I compiled with nls enabled and without, both works. Only the dll which
comes with the Win installer causes the problem. Any ideas what could be
the problem here?

>> I also noticed that the HTML code in PQprint is not very clean and
>> sometimes even wrong, e.g. it has <centre> instead of <center>.
>
> Fixed in 8.1.X.

As already mentioned, there is also a wrong attribute align=high and as
I just saw, also align=left and align=right attributes without quotes.

-- Christoph