[HACKERS] FETCH from scroll cursor does not return count in libpq PQcmdStatus

2007-02-18 Thread Knut P. Lehre
Using libpq with pg 8.2.1 on WinXP Pro SP2. After a PQExec with a fetch from a scroll cursor, I only get "FETCH" from PQcmdStatus, and not "FETCH count" as described in the 8.2.1 docs. However, PQntuples returns the number of fetched rows. If I replace the FETCH by a MOVE, PQcmdStatus returns "

Re: [HACKERS] Windows installer and dlls

2006-12-31 Thread Knut P. Lehre
>> I uninstalled postgresql, removed the 5 files mentioned above from >> system32. When I installed 8.2.0 again, the installer reported that >> "The installer has detected an incompatible version of OpenSSL >> installed in your system PATH. PostgreSQL requires OpenSSL 0.9.7 or >> later. If you remo

[HACKERS] Windows installer and dlls

2006-12-25 Thread Knut P. Lehre
Installing postgresql 8.2.0 on Windows XP Pro SP2 using the msi installer dated 2006-12-04, with libeay32.dll and ssleay32.dll (both dated 2005-07-06) (and libiconv-2.dll, libintl-2.dll, and libpq.dll) from a previous installation (of version 8.0.5) already present in c:\windows\system32. These

Re: [HACKERS] SSL client crt verification

2005-08-29 Thread Knut P Lehre
To the last sentence in my last post "Re: SSL client crt verification": "From docs I understand that I only have to set SSL = true in postgresql.conf to switch it on (in addition to providing the crt and key files)." I should have added: "...and using "hostssl" in pg_hba.conf (although "host" al

Re: [HACKERS] SSL client crt verification

2005-08-29 Thread Knut P Lehre
>> Server: 7.4.8 on Red Hat EL4. Client psql 8.0.3 on WinXP. Using a >> test server.crt and server.key, as described in 8.0 docs 16.8, I can >> activate SSL encryption (WinXP 8.0.3 psql reports "SSL Connection" >> at connect), and as expected, the server log reports that root.crt >> is not found.

[HACKERS] SSL client crt verification

2005-08-26 Thread Knut P Lehre
Tried doc search, pgsql-general and #postgresql. Server: 7.4.8 on Red Hat EL4. Client psql 8.0.3 on WinXP. Using a test server.crt and server.key, as described in 8.0 docs 16.8, I can activate SSL encryption (WinXP 8.0.3 psql reports "SSL Connection" at connect), and as expected, the server log re