Re: [HACKERS] Roadmap for a Win32 port

2002-06-06 Thread Robert Schrem
Hi Bruce, You obviosuly missed my recent posting advertising the homepage of Konstantin Knizhnik? Make sure to have a look: http://www.garret.ru/~knizhnik/ You find there -everything- concerning multiplatform IPC, threading and even some extraordinary, complete database backends that are

Re: [HACKERS] Straight-from-the-horses-mouth dept

2002-06-06 Thread Hannu Krosing
On Thu, 2002-06-06 at 07:18, Tom Lane wrote: I've been having a lot of fun here at the SIGMOD annual conference, attaching faces to names like Stonebraker, Hellerstein, Aoki, Seltzer (if these do not ring a bell, you ain't read enough Postgres source code lately). I felt I had to pass along

Re: [HACKERS] PostgreSQL and Windows2000 and defunct processes

2002-06-06 Thread Yutaka tanida
Hi. On Thu, 06 Jun 2002 16:23:29 +0930 Steven Vajdic [EMAIL PROTECTED] wrote: How to get read of those "defunct" processes? What version of cygipc and cygwin do you use? --- Yutaka tanida[EMAIL PROTECTED] $BFf$N(BWebsite http://www.hi-net.zaq.ne.jp/yutaka/ ---(end

Re: [HACKERS] Roadmap for a Win32 port

2002-06-06 Thread Bruce Momjian
Jan Wieck wrote: One solution is to return to that for Win32 only, so instead of doing: initialization() want for connection() fork backend() we do for Win32: want for connection() exec backend() initialization() Summarizes pretty much what we

Re: [HACKERS] PostgreSQL and Windows2000 and defunct processes

2002-06-06 Thread SHELTON,MICHAEL (Non-HP-Boise,ex1)
Steven, I found the following snippet in MSDN under CreateProcess: The created process remains in the system until all threads within the process have terminated and all handles to the process and any of its threads have been closed through calls to CloseHandle. The handles for both the process

Re: [HACKERS] Straight-from-the-horses-mouth dept

2002-06-06 Thread Tom Lane
Hannu Krosing [EMAIL PROTECTED] writes: rant One thing I think we have stripped too much is time travel. Actually, I was just discussing that at last night's dinner with someone whose name I forget at the moment (I have his card, but not on me). He claimed to know how to support time travel as

[HACKERS] patch for contrib/intarray (7.2 and 7.3) (fwd)

2002-06-06 Thread Oleg Bartunov
Patch to contrib/intarray is attached to this message. Please apply it to 7.2 and CVS Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University

Re: [HACKERS] non-standard escapes in string literals

2002-06-06 Thread Peter Eisentraut
Lincoln Yeoh writes: However raw control characters can still cause problems in the various stages from the source to the DB. I still don't see why. You are merely speculating about implementation fallacies that aren't there. -- Peter Eisentraut [EMAIL PROTECTED]

Re: [HACKERS] Roadmap for a Win32 port

2002-06-06 Thread Peter Eisentraut
Bruce Momjian writes: Lots of our code requires a unix shell and utilities. Will we continue using cygwin for this? We should probably get rid of using shell scripts for application programs altogether, for a number of reasons besides this one, such as the inability to properly handle input

Re: [HACKERS] pgaccess.org - invitation for a working meeting

2002-06-06 Thread Josh Berkus
Folks, If I might just say ... I think it's phenominal that somebody has started working on the PGAccess code again and I really look forward to testing (and documenting!) your work. If you don't read the Novice list, new Postgres users have been dying for a PGAccess update for the last year.

Re: [HACKERS] pgaccess.org - invitation for a working meeting

2002-06-06 Thread Iavor Raytchev
Thanks Josh, Good, encouraging words. There are two mailing lists - please feel free to make them popular - [EMAIL PROTECTED] [EMAIL PROTECTED] Both are run on qmail/ezmlm, for help send a blank e-mail to - [EMAIL PROTECTED] [EMAIL PROTECTED] The lists are not moderated. Please,

Re: [HACKERS] pgaccess.org - invitation for a working meeting

2002-06-06 Thread Bruce Momjian
Iavor Raytchev wrote: pgaccess has no meaning outside PostgreSQL. We do not try to steal it or take it over,... One day I should write a page how the whole things started, so that I do not have to explain it every time. I have not heard --- where are you going to keep the master CVS? --

Re: [HACKERS] Cooperation

2002-06-06 Thread ISHIKAWA Toshiyuki
Dann Corbit wrote: I apologize for my English language message. I am unable to speak Japanese. We do have a native Japanese speaker here, who could be called upon if necessary. There is no need to aplogize writing an e-mail in English. It's global standards, but some portion is a bit

Re: [HACKERS] [GENERAL] Re : Solaris Performance - 64 bit puzzle

2002-06-06 Thread Bruce Momjian
Dann Corbit wrote: TODO reverted to be: Add BSD-licensed qsort() for Solaris My guess is that your test case didn't tickle the bug. I am the author of several special sort functions [I wrote the sorting chapter in this book: http://users.powernet.co.uk/eton/unleashed/]. I

Re: [HACKERS] Roadmap for a Win32 port

2002-06-06 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian writes: Lots of our code requires a unix shell and utilities. Will we continue using cygwin for this? We should probably get rid of using shell scripts for application programs altogether, for a number of reasons besides this one, such as the

Re: [HACKERS] non-standard escapes in string literals

2002-06-06 Thread Lincoln Yeoh
Yes it's speculation. The implementation at the DB isn't there, neither are the associated DBD/JDBC/ODBC drivers for it. Basically if the fallacies aren't in postgresql _if_ the decision is to implement it, I'd be happy. I was just noting (perhaps superfluously) that backspaces and friends

Re: [HACKERS] PostgreSQL and Windows2000 and defunct processes

2002-06-06 Thread Steven Vajdic
Hi Michael/Yutaka, Thanks for your reply. I discovered the cause of the problem (I think) - I just do not know why it happens. PROBLEM (again): DEFUNCT processes under Win2K not seen under Win98. I am running cygwin-2.125.2.10 (postgresql 7.1) and cigipc-1.11-1 installed in Jan 2002. Prior

Re: [HACKERS] Redhat 7.3 time manipulation bug

2002-06-06 Thread Bruce Momjian
Tom Lane wrote: Thomas Lockhart [EMAIL PROTECTED] writes: Why should we rely on broken glibc and the standard? Why don't we make our own mktime() and use it on all platforms. The downside to doing that is that we then take over maintenance of the code and, more importantly, the

Re: [HACKERS] Redhat 7.3 time manipulation bug

2002-06-06 Thread Bruce Momjian
Trond Eivind Glomsrød wrote: On Tue, 21 May 2002, Lamar Owen wrote: On Tuesday 21 May 2002 11:04 am, Manuel Sugawara wrote: I see. This behavior is consistent with the fact that mktime is supposed to return -1 on error, but then is broken in every other Unix implementation that I

Re: [HACKERS] revised sample SRF C function; proposed SRF API

2002-06-06 Thread Joe Conway
Tom Lane wrote: Definitely better. I'd suggest also thinking about whether the same/similar macros can support functions that return a set of a scalar (non-tuple) datatype. In my mind, the cleanest design would be some base macros that support functions-returning-set (of anything), and if

Re: [HACKERS] SASL, compression?

2002-06-06 Thread Bruce Momjian
Tom Lane wrote: Bear Giles [EMAIL PROTECTED] writes: 1) add SASL. This is a new standards-track protocol that is often described as PAM for network authentication. PostgreSQL could remove *all* protocol-specific authentication code and use standard plug-in libraries instead.

Re: [HACKERS] Use of /etc/services?

2002-06-06 Thread Bruce Momjian
Peter Eisentraut wrote: Since we now have an official entry in /etc/services, shouldn't we be able to make use of it, by using getservbyname() if a nonnumeric port number is specified? Is any OS actually shipping us in /etc/services? -- Bruce Momjian|

Re: [HACKERS] Per tuple overhead, cmin, cmax, OID

2002-06-06 Thread Bruce Momjian
Tom Lane wrote: Manfred Koizar [EMAIL PROTECTED] writes: No comment on a planned 7.3 timeframe? :-( I think we are planning to go beta in late summer (end of August, say). Probably in July we'll start pressing people to finish up any major development items, or admit that they won't

Re: [HACKERS] Use of /etc/services?

2002-06-06 Thread Curt Sampson
On Fri, 7 Jun 2002, Bruce Momjian wrote: Peter Eisentraut wrote: Since we now have an official entry in /etc/services, shouldn't we be able to make use of it, by using getservbyname() if a nonnumeric port number is specified? Is any OS actually shipping us in /etc/services? NetBSD will

Re: [HACKERS] Per tuple overhead, cmin, cmax, OID

2002-06-06 Thread Bruce Momjian
Tom Lane wrote: Manfred Koizar [EMAIL PROTECTED] writes: what about WITHOUT OIDS? I know dropping the OID from some tables and keeping it for others is not trivial, because t_oid is the _first_ field of HeapTupleHeaderData. I'm vaguely considering a few possible implementations and