Re: [GENERAL] Re: ZeroFill(.../pg_xlog/xlogtemp.20148) failed: No such file or directory

On Wed, May 23, 2001 at 11:39:15AM -0600, Chris Jones wrote: > No, it could be any number of other things. The first that comes to > mind is EINTR. How about something closer to: Hmm. Actually, write(2) shouldn't return EINTR; it should return a short read count. But other e

Re: [GENERAL] Re: ZeroFill(.../pg_xlog/xlogtemp.20148) failed: No such file or directory

= lastwritten; } } Chris -- [EMAIL PROTECTED] ----- Chris JonesSRI International, Inc. www.sri.com PGP signature ---(end of b

Re: [GENERAL] Re: Query not using index

f non-NULL values. Chris -- [EMAIL PROTECTED] ----- Chris JonesSRI International, Inc. www.sri.com PGP signature ---(end of broadc

Re: [GENERAL] Re: a primer on trigger?

t isn't this what two-phase commit is for? Chris -- [EMAIL PROTECTED] ----- Chris JonesSRI International, Inc. www.sri.com PGP si

Re: [GENERAL] linux/bsd

-- [EMAIL PROTECTED] ----- Chris JonesSRI International, Inc. www.sri.com PGP signature ---(end of broadcast)--- TIP 4

Re: [GENERAL] explain shows lots-o-preliminary sorting

-> Seq Scan on _edu (cost=0.00..1.04 rows=4 width=28) > > > -> Sort (cost=1.52..1.52 rows=17 width=178) > > > -> Seq Scan on _course (cost=0.00..1.17 rows=17 width=178) > > > > > > EXPLAIN -- [EMAIL PROTECTED] -

Re: [GENERAL] URL for gmake

IL PROTECTED] ----- Chris JonesSRI International, Inc. www.sri.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subs

Re: [GENERAL] vacuum analyze again...

cally choose the appropriate method based on the table size. Chris -- [EMAIL PROTECTED] ----- Chris JonesSRI International, Inc. www.sri.com

Re: Failover (was Re: [GENERAL] PostgreSQL over NFS?)

ou can get it from (I think) www.postgresql.com for 7.0. Chris -- [EMAIL PROTECTED] --------- Chris JonesSRI International, Inc. www.sri.com

Re: [GENERAL] strange query plans

Stephan Szabo <[EMAIL PROTECTED]> writes: > On 30 Nov 2000, Chris Jones wrote: > > > PG seems to be choosing a sub-optimal query plan. It's doing a > > sequential scan of a 12-tuple table, instead of an index scan for > > the 16 matching rows. Running PG

Re: [GENERAL] Regular expressions syntax: is \ the escape character ?

second time it gets parsed, the '\\' -> '\', which is what you want. (Haven't tested it, but I've seen similar things in other places.) Chris -- [EMAIL PROTECTED] Chris Jones System Administrator, Right Now Technologies, Inc. "Is this going to be a stand-up programming session, sir, or another bug hunt?"

Re: [GENERAL] DHCP and pg_hba.conf

re reasonable to allow something like "%.accounting.mycompany.com" in an ACL. Chris -- ---- [EMAIL PROTECTED] Chris Jones System Administrator, Right Now Technologies, Inc. "Is this going to be a stand-up programming session, sir, or another bug hunt?"

[GENERAL] database corruption?

a few weeks ago. This is on an i386 running NetBSD 1.4.1, if that makes a difference. TIA for any help. Chris -- ---- [EMAIL PROTECTED] Chris Jones System Administrator, Right Now Technologies, Inc. "Is this going to be a stand-up programming session, sir, or another bug hunt?"