Re: [HACKERS] Mapping Oracle types to PostgreSQL types

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: "scott.marlowe" <scott.marlowe@ihs.com>
Cc: Justin Clift <justin@postgresql.org>, jm@poure.com, Bruno LEVEQUE <bruno.leveque@net6d.com>, pgsql-advocacy@postgresql.org, Robert Treat <xzilla@users.sourceforge.net>, Vincent Harcq <vha@audaxis.com>, Jean-Paul ARGUDO <jpargudo@free.fr>
Date: 2003-10-21T22:22:52Z
Lists: pgsql-hackers
scott.marlowe wrote:
> On Tue, 21 Oct 2003, Bruce Momjian wrote:
> 
> > Justin Clift wrote:
> > > Hi guys,
> > > 
> > > Jorg Janke (the "main" Compiere person) and I had a brief dicussion last 
> > > year.
> > > 
> > > Pretty much he asked if PostgreSQL (either the company and/or the 
> > > community) would be interested in _making PostgreSQL compatible with 
> > > Compiere_ or if not, then how about we and _make and maintain_ a fork of 
> > > PostgreSQL that did the right kind of transaction support to work 
> > > Compiere.  The return for doing that would have been for PostgreSQL to 
> > > the be Compiere "default" (recommended) database.
> > 
> > It is hard to understand that if he is willing to make PostgreSQL the
> > default for Compiere, why he would refuse to include any changes to
> > allow Oracle and PostgreSQL to both work.
> 
> But if what he wants is nested transactions, then I could see him paying 
> for development providing better ROI than forking the code.  Is that what 
> was meant by "the right kind of transaction support" ?

Oh, that makes complete sense.  You can't really code around the lack of
nested transactions, at least not cleanly.  Let's get nested
transactions and go back to them.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073