Re: [ADMIN] [DBmirror Issue] recordchange() dies in packageData unless there is a PRIMARY KEY on DELETE and UPDATEs.

2002-09-26 Thread Rajesh Kumar Mallah.
Hi Steven, Your most recent version pending.c does not crashes postmaster anymore when PRIMARY KEYS are missing. Instead it raises notices and errors: tradein_clients= BEGIN work; UPDATE iid_listing set city='DELHI testing' where list_id=23312; BEGIN NOTICE: Could not select primary index key

[ADMIN] hardware question

2002-09-26 Thread Andreas Schmitz
Hello *, I've got a question concerning hardware. We're planning to replace our SUNS (E3500,E3000,E450 etc) with multiprocessor XEON boards. Is there any recommendation or experience about this type of hardware ? kind regards -andreas -- Andreas Schmitz - Phone +49 201 8501 318

[ADMIN] Feature or Bug Questions

2002-09-26 Thread Derek Neighbors
There are few items I was wondering if I could get an answer as to whether they are features or bugs and if they are bugs the release in which they might be rectified. Issue #1 If you drop a table and then recreate it. Trying to access a view on that table returns error about OID not being

Re: [ADMIN] Feature or Bug Questions

2002-09-26 Thread Andrew Sullivan
On Thu, Sep 26, 2002 at 08:54:12AM -0700, Derek Neighbors wrote: If you drop a table and then recreate it. Trying to access a view on that table returns error about OID not being found. If you drop and recreate the view the problem goes away. Yes. This is a known problem. I _think_ 7.3

Re: [ADMIN] hardware question

2002-09-26 Thread Adam Erickson
I assume you'll be running Linux on this? We're running a 4x700 right now, it's very dependable. But be careful, you're getting yourself into (as far as Linux goes) very high end hardware. It's easy enough to find people who can support a uni or dual-proc box. Finding expertise on 4-way or

Re: [ADMIN] hardware question

2002-09-26 Thread Dan Hrabarchuk
A note on your last point. We have a bunch of older SUN boxes around here. e450, e250, etc. The 2MB L2 cache un the UltraSparc 2 does allow for a high load. And for their era they were sweet chips, still are. But the #1 reason in my mind to move from Sun to an Lintel box would be cost. Sun is

Re: [ADMIN] hardware question

2002-09-26 Thread Andrew Sullivan
On Thu, Sep 26, 2002 at 12:25:51PM -0500, Adam Erickson wrote: I am curious, why are you getting away from Sun? I've been under the impression that Sun hardware kills IA32 when it comes time to play. (eg. high load) Am I reading too much FUD these days? Maybe. I can say for sure that an

[ADMIN] compiling version 7.2.2 on AIX 4.3.1 can't find F_OIDEQ

2002-09-26 Thread Ligia Pimentel
Hi. I'm trying to install postgres 7.2.2 on AIX 4.3.1 (on a powerpc bull) and I get this message on gmake: gmake[4]: Entering directory `/desa/postgres/postgresql-7.2.2/src/backend/access/heap' xlc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I../../../../src/include -c -o tuptoaste r.o

Re: [ADMIN] compiling version 7.2.2 on AIX 4.3.1 can't find F_OIDEQ

2002-09-26 Thread Tom Lane
Ligia Pimentel [EMAIL PROTECTED] writes: I downloaded the tar files for version 7.2.1 and the problem doesn't exist in that versionso I already installed postgres and i'm testing it. So far, so good. It's hard to believe that there'd be any difference between 7.2.2 and 7.2.1 on this