Re: [HACKERS] 2-phase commit

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [HACKERS] 2-phase commit
Date: 2003-08-29 03:12:52
Message-ID: m3vfshi2bv.fsf@chvatal.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

Oops! bruno(at)wolff(dot)to (Bruno Wolff III) was seen spray-painting on a wall:
> On Wed, Aug 27, 2003 at 22:46:58 -0700,
> Joe Conway <mail(at)joeconway(dot)com> wrote:
>>
>> That's an interesting observation, because I've long thought
>> PeopleSoft ought to support Postgres too. From what I recall, their
>> database schema is *very* database neutral (at least as of PSFT
>> version 7.x) and fairly simple (we ran it on MSSQL 6.5). It would
>> probably be pretty easily ported to run on Postgres.
>
> In my opinion it is too database agnostic. They pretty much just use
> the DB as a file. From what I have seen of the system it is one big
> hack.

Ah, so it's like the way SAP R/3's HR module works. (I expect I'm the
only one around that is more than passing familiar with "cluster
tables"; quite supremely nonrelational stuff, and quite
bletcherous...)

To a great extent this comes from the nature of the application. HR
is all about collecting together "documents," and these applications
replace "paper" with "pseudopaper."

> They aren't big on using referential integrity to keep the data
> clean.

Ditto for SAP R/3; "cleanliness" is, there, imposed by only using
their applications to do updates, which includes writing your software
to invoke their functions.
--
(reverse (concatenate 'string "gro.mca" "@" "enworbbc"))
http://www.ntlug.org/~cbbrowne/linuxxian.html
ASSEMBLER is a language. Any language that can take a half-dozen
keystrokes and compile it down to one byte of code is all right in my
books. Though for the REAL programmer, assembler is a waste of
time. Why use a compiler when you can code directly into memory
through a front panel.

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Francois Suter 2003-08-29 07:02:25 Help on some concepts
Previous Message Joe Conway 2003-08-29 00:50:40 Re: [HACKERS] 2-phase commit

Browse pgsql-hackers by date

  From Date Subject
Next Message Ron Johnson 2003-08-29 03:20:10 Re: Replication Ideas
Previous Message Marc G. Fournier 2003-08-29 03:06:59 Re: Bumping block size to 16K on FreeBSD...