Re: [BUGS] More SSL questions..

2005-01-04 Thread T.J.
After some more screwing around, I'm not entirely certain windows is even trying to open my certs. After repeatedly trying to connect it seemed like I was getting an equal amount of the sslv3 and SSL SYSCALL errors, whether or not the certs were (where I thought?) windows was looking for them..

[BUGS] pg_dump --oids fails when default_with_oids = off

2005-01-04 Thread Michael Fuhr
PostgreSQL 8.0.0rc3 When default_with_oids is set to "off", pg_dump --oids fails with the following error: % pg_dump --oids test pg_dump: inserted invalid OID This prevents the ability to dump OIDs for tables that were created WITH OIDS. The workaround is to set default_with_oids to "on". The

Re: [BUGS] More SSL questions..

2005-01-04 Thread Tom Lane
"T.J." <[EMAIL PROTECTED]> writes: > Which leads me to my next question; that function client_cert_cb, does > it ever get executed on windows? :) Um. Looks like someone ifdef'd it out :-(. In fact, if you look through fe-secure.c, you'll see that just about all the SSL code is ifdef'd out on Wi

Re: [BUGS] More SSL questions..

2005-01-04 Thread T.J.
Yeah I already tried removing the ifdef's...oh BOY was it not happy :'( Tom Lane wrote: "T.J." <[EMAIL PROTECTED]> writes: Which leads me to my next question; that function client_cert_cb, does it ever get executed on windows? :) Um. Looks like someone ifdef'd it out :-(. In fact, if yo

Re: [BUGS] More SSL questions..

2005-01-04 Thread Tom Lane
I wrote: > win32 hackers, anyone know why it's like this? Looking through the code, it seems that it's because someone thought that breaking SSL would be easier than replacing the pqGetpwuid() calls that are used to find out the user's home directory. Does Windows even have a concept of home dire

Re: [BUGS] pg_dump --oids fails when default_with_oids = off

2005-01-04 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > When default_with_oids is set to "off", pg_dump --oids fails with > the following error: > % pg_dump --oids test > pg_dump: inserted invalid OID > Should the temporary table be created WITH OIDS, Looks that way. Good catch. rega

Re: [BUGS] More SSL questions..

2005-01-04 Thread Matthew T. O'Connor
Tom Lane wrote: I wrote: win32 hackers, anyone know why it's like this? Looking through the code, it seems that it's because someone thought that breaking SSL would be easier than replacing the pqGetpwuid() calls that are used to find out the user's home directory. Does Windows even have a

Re: [BUGS] More SSL questions..

2005-01-04 Thread Tom Lane
"Matthew T. O'Connor" writes: > Tom Lane wrote: >> Does Windows even have a concept of home directory? What would be a >> reasonable equivalent to ~/.postgresql/ ? > The versions of windows that the port supports (NT4, 2000, 2003, XP) do > have home directories. OK ... are you supposed to find

Re: [BUGS] More SSL questions..

2005-01-04 Thread Matthew T. O'Connor
Tom Lane wrote: OK ... are you supposed to find it out by looking at the environment vars, or is there another API defined? I am planning to consolidate the platform dependency into a function defined like static bool pqGetHomeDirectory(char *buf, int bufsize) { -- O

Re: [pgsql-hackers-win32] [BUGS] More SSL questions..

2005-01-04 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > I think CSIDL_APPDDATA is probably the way to go, but one of the heavy > Windows hitters will know better than I do. Now that I look at it, there are several places that are depending on getenv("HOME") or getenv("USERPROFILE") (on Windows) as the meani

Re: [pgsql-hackers-win32] [BUGS] More SSL questions..

2005-01-04 Thread John R Pierce
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: I think CSIDL_APPDDATA is probably the way to go, but one of the heavy Windows hitters will know better than I do. Now that I look at it, there are several places that are depending on getenv("HOME") or getenv("USERPROFILE") (on Windows)

Re: [pgsql-hackers-win32] [BUGS] More SSL questions..

2005-01-04 Thread Tom Lane
John R Pierce <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Seems like we should be consistent about this --- either we trust $HOME >> or we don't. > more fun. I just checked the environment of the postmaster service on a > win2000 Pro system (using www.sysinternals.com's excellent Process Ex

Re: [pgsql-hackers-win32] [BUGS] More SSL questions..

2005-01-04 Thread John R Pierce
Actually, the server doesn't depend on home directories in any way shape or form. The places that we are concerned about are on the client side, either in libpq or in psql. So what we have to think about is the environment that libpq might see. libpq could be called from a service, such as ineti

Re: [pgsql-hackers-win32] [BUGS] More SSL questions..

2005-01-04 Thread John R Pierce
win2000 Pro system (using www.sysinternals.com's excellent Process Explorer tool, btw). HOME is not set. USERPROFILE is set to "C:\Documents and Settings\postgres"... For services that are running as 'NT AUTHORITY\SYSTEM', the profile is "C:\Documents and Settings\Default User" (and the USER

Re: [pgsql-hackers-win32] [BUGS] More SSL questions..

2005-01-04 Thread Matthew T. O'Connor
Tom Lane wrote: John R Pierce <[EMAIL PROTECTED]> writes: more fun. I just checked the environment of the postmaster service on a win2000 Pro system (using www.sysinternals.com's excellent Process Explorer tool, btw). HOME is not set. USERPROFILE is set to "C:\Documents and Settings\postg

[BUGS] Two broken linksin doc/FAQ_DEV

2005-01-04 Thread Tanel Hiir
Stumbled over two broken links in Developer's Frequently Asked Questions (rev=1.78). Document heading contains: http://www.PostgreSQL.org/docs/faqs/FAQ_DEV.html should: http://developer.postgresql.org/readtext.php?src/FAQ/FAQ_DEV.html 1.5) contains: http://developers.postgresql.org should

[BUGS] BUG #1372: Service won't start with tcpip_socket = true

2005-01-04 Thread Graham Robson
The following bug has been logged online: Bug reference: 1372 Logged by: Graham Robson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP SP2 Description:Service won't start with tcpip_socket = true Details: Trying to setup TCP/IP

[BUGS] BUG #1371: Short-circuit evaluation on PL/PgSQL

2005-01-04 Thread Aguinaldo Possatto
The following bug has been logged online: Bug reference: 1371 Logged by: Aguinaldo Possatto Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Description:Short-circuit evaluation on PL/PgSQL Details: an exception is raised when th

Re: [pgsql-hackers-win32] [BUGS] More SSL questions..

2005-01-04 Thread Joshua D. Drake
Tom Lane wrote: I wrote: win32 hackers, anyone know why it's like this? Looking through the code, it seems that it's because someone thought that breaking SSL would be easier than replacing the pqGetpwuid() calls that are used to find out the user's home directory. Does Windows even have a concept

Re: [pgsql-hackers-win32] [BUGS] More SSL questions..

2005-01-04 Thread Andrew Dunstan
Matthew T. O'Connor wrote: Tom Lane wrote: If someone can whip up and test a WIN32 version of this, I'll take care of the rest. I can't do the coding, but I took a quick look at msdn and I think this is relevant: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/shellcc/platfo

Re: [BUGS] BUG #1371: Short-circuit evaluation on PL/PgSQL

2005-01-04 Thread Tom Lane
"Aguinaldo Possatto" <[EMAIL PROTECTED]> writes: > an exception is raised when this block is being executed: > if ( ((tg_op = 'INSERT') and > (new.field is not null)) or > ((tg_op = 'DELETE') and > (old.field is not null)) ) > then > ... > end if; > the error is : > "SQL