Re: [pgsql-hackers-win32] [HACKERS] What's left?

2004-03-03 Thread Ken Hirsch
Merlin Moncure [EMAIL PROTECTED] wrote: Greg Stark wrote: imposed no such conditions. If Microsoft wanted to release a Microsoft Postgresql under a completely proprietary license they would be free to do I have often wondered, in a completely off-topic and unproductive sort of way, if exactly

Re: [HACKERS] Password security question

2002-12-17 Thread Ken Hirsch
http://msdn.microsoft.com/library/en-us/dncode/html/secure10102002.asp ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: Geometry test on NetBSD (was Re: [HACKERS] RC1?)

2002-11-20 Thread Ken Hirsch
Bruce Momjian [EMAIL PROTECTED] wrote: Tom, can you clarify why -0 is valid. Is it for _small_ near zero values that are indeed negative? Branch Cuts for Complex Elementary Functions, or Much Ado About Nothing's Sign Bit W. Kahan; ch. 7 in _The State of the Art in Numerical Analysis_ ed.

Re: [HACKERS] Proposed LogWriter Scheme, WAS: Potential Large

2002-10-07 Thread Ken Hirsch
I sent this yesterday, but it seems not to have made it to the list... I have a couple of comments orthogonal to the present discussion. 1) It would be fairly easy to write log records over a network to a dedicated process on another system. If the other system has an uninterruptible

Re: [HACKERS] New string functions; initdb required

2002-06-12 Thread Ken Hirsch
Thomas Lockhart wrote: Right. I'm not certain about the regex syntax defined by SQL99; I used the syntax that we already have enabled and it looks like we have a couple of other variants available if we need them. If someone wants to research the *actual* syntax specified by SQL99 that would

Re: [HACKERS] Suggestion for optimization

2002-04-05 Thread Ken Hirsch
In addition, this seems to be the canonical paper on snapshot isolation: http://citeseer.nj.nec.com/berenson95critique.html There is an excellent, more recent paper, Generalized Isolation Level Definitions (http://citeseer.nj.nec.com/adya00generalized.html).

Re: [HACKERS] When scripting, which is better?

2001-10-01 Thread Ken Hirsch
Justin Clift wrote: if [ x$foo = x ]; then This is the safest way. It prevents problems when $foo begins with with a - I don't know about your first question, though. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [HACKERS] Pre-forking backend

2001-09-30 Thread Ken Hirsch
Doug McNaught wrote: You can pass open file descriptors across Unix domain sockets on most systems, which is a possible way to address the problem, but probably not worth it for the reasons discussed earlier. I think that it does solve the problem. The only drawback is that it's not

Re: [HACKERS] Pre-forking backend

2001-09-29 Thread Ken Hirsch
Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: How hard would it be to pre-fork an extra backend How are you going to pass the connection socket to an already-forked child process? AFAIK there's no remotely portable way ... No idea but it seemed like a

Re: [HACKERS] Pre-forking backend

2001-09-29 Thread Ken Hirsch
Tom Lane wrote: This approach would only work as far as saving the fork() call itself, not the backend setup time. Not sure it's worth the trouble. I doubt that the fork itself is a huge component of our start time; it's setting up all the catalog caches and so forth that's expensive. On

Re: [HACKERS] [OT] http://www.postgresql.ca.org

2001-09-20 Thread Ken Hirsch
http://anything.ca.org goes to the same IP address. It has nothing to do with postgres - Original Message - From: Serguei Mokhov [EMAIL PROTECTED] To: PostgreSQL Hackers [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 8:57 AM Subject: [HACKERS] [OT] http://www.postgresql.ca.org

Re: [HACKERS] Porting to Native WindowsNT/2000

2001-09-03 Thread Ken Hirsch
Ian Lance Taylor [EMAIL PROTECTED] wrote: Dwayne Miller [EMAIL PROTECTED] writes: Well, for one I have no idea what cygwin is, or what it does to your system, or what security vulnerabilities it might add to your system. It comes with alot of stuff that I may or may not need, but

Re: [HACKERS] Re: From TODO, XML?

2001-07-29 Thread Ken Hirsch
mlw [EMAIL PROTECTED] wrote: Frank Ch. Eigler wrote: : So a parser that can scan a DTD and make a usable create table (...) : line would be very helpful. [...] Hmm, but hierarchically structured documents such as XML don't map well to a relational model. The former tend to be

[HACKERS] Re: New Linux xfs/reiser file systems

2001-05-04 Thread Ken Hirsch
log metadata changes. I don't have a machine with XFS installed and it will be at least a week before I could get around to a build. Any volunteers? Ken Hirsch ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [HACKERS] Re: New Linux xfs/reiser file systems

2001-05-04 Thread Ken Hirsch
Glomsrød [EMAIL PROTECTED] has volunteered to test on XFS. The easier we make it, the more help we'll get. Ken Hirsch ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Learning from other open source databases

2001-04-30 Thread Ken Hirsch
. There's also the Shore data manager. While not a complete SQL database, I've wondered if it could actually be spliced into PostgreSQL, since the licenses appear compatible. http://www.cs.wisc.edu/shore/ Ken Hirsch ---(end of broadcast)--- TIP

Re: [HACKERS] Hardcopy docs available

2001-04-20 Thread Ken Hirsch
Okay, you're right. I just updated my Ghostscript to 7.00 (just out) and it produced very nice PDFs. I can upload them somewhere if you give me an FTP address. Ken Hirsch - Original Message - From: "Bruce Momjian" [EMAIL PROTECTED] To: "Ken Hirsch" [EMAIL P

Re: [HACKERS] Re: TODO list

2001-04-05 Thread Ken Hirsch
write the block. Ken Hirsch All your database are belong to us. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Allowing WAL fsync to be done via O_SYNC

2001-03-16 Thread Ken Hirsch
From: "Bruce Momjian" [EMAIL PROTECTED] Could anyone consider fork a syncer process to sync data to disk ? build a shared sync queue, when a daemon process want to do sync after write() is called, just put a sync request to the queue. this can release process from blocked on writing

Re: [HACKERS] rtrim giving weird result

2001-03-14 Thread Ken Hirsch
The second parameter to "rtrim" is interpreted as a set of characters and rtrim: "Returns string with final characters removed after the last character not in set" So rtrim("center_out_opto", "_opto") returns "center_ou" because "u" is not in the set {o, p, t, _} but all the characters after

Re: [HACKERS] WAL SHM principles

2001-03-13 Thread Ken Hirsch
mailing list that mlock() was a good way to insure the write-ahead condition. Ken Hirsch ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [HACKERS] WAL SHM principles

2001-03-13 Thread Ken Hirsch
mailing list that mlock() was a good way to insure the write-ahead condition. Ken Hirsch ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])