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 wou
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 powe
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 Analysi
an grow without bound for long-lived transactions, but it's very
straightforward and fast.
Ken Hirsch
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
http://msdn.microsoft.com/library/en-us/dncode/html/secure10102002.asp
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ust match a word at the beginning of the block. It
gets changed each time you 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]
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"
res, Mariposa, and Postgres 4.2.
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
sync since they only 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
e have anything?
Already, Trond Eivind 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
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 ten
Thomas Lockhart <[EMAIL PROTECTED]> wrote:
> We have a copy of an SQL99 draft which seems to be reasonably complete.
> afaik we haven't come across an actual released version. Let me know if
> you want me to forward it; perhaps it is on the ftp or web site?
ftp://ftp.postgresql.org/pub/doc/sql/s
"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 n
You may be interested in
http://www.ietf.org/internet-drafts/draft-ietf-syslog-reliable-12.txt which
builds a reliable syslog protocol on top of BEEP. There are free
implementations of BEEP in C and Java at http://beepcore.org
- Original Message -
From: "Matthew Hagerty" <[EMAIL PROTECTE
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
port
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?
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 i
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.
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
> 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).
ut other systems. Does anybody know what the POSIX.1b
standard says?
It was even suggested to me on the linux-fsdev mailing list that mlock() was
a good way to insure the write-ahead condition.
Ken Hirsch
---(end of broadcast)---
TIP 3: if posti
ut other systems. Does anybody know what the POSIX.1b
standard says?
It was even suggested to me on the linux-fsdev mailing list that mlock() was
a good way to insure the write-ahead condition.
Ken Hirsch
---(end of broadcast)---
TIP 2: you ca
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
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
"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
25 matches
Mail list logo
