Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Mapping Oracle types to PostgreSQL

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>,Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,Justin Clift <justin(at)postgresql(dot)org>, jm(at)poure(dot)com,Bruno LEVEQUE <bruno(dot)leveque(at)net6d(dot)com>,pgsql-advocacy(at)postgresql(dot)org, Vincent Harcq <vha(at)audaxis(dot)com>,Jean-Paul ARGUDO <jpargudo(at)free(dot)fr>
Subject: Re: [HACKERS] Mapping Oracle types to PostgreSQL
Date: 2003-10-21 21:26:29
Message-ID: 1066771589.2069.7367.camel@camel (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackers
On Tue, 2003-10-21 at 17:00, Josh Berkus wrote:
> Scott,
> 
> > > 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" ?
> 
> If he wanted nested transactions, and was willing to pay for development, I 
> can't imagine us turning him down.  Nested xtn have been on the TODO list for 
> years.
> 

I think his (his being the compiere guy) point was that if someone in
the postgresql community wanted to implement some of the more difficult
features into postgresql that he would make it the default db for
compiere.  however he tried himself to raise funds to make it happen and
he could not, so it's on the postgresql community to make it happen
now.  

The big question as I see it is whether he is willing to make
incremental steps to make compiere more postgresql compatible if it
might hurt the oracle side (the nvarchar2 to varchar data type change is
a good example of this). If he is willing to make these changes then all
is good, if not then istm that a fork would be the likely outcome. 

course, its a lot of speculation and discussion that should probably
happen on the compiere lists, they have discussed this issue before and
would do so again, and as bruce said, getting the compiere community
support is the first step.  

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-10-21 22:22:52
Subject: Re: [HACKERS] Mapping Oracle types to PostgreSQL types
Previous:From: Josh BerkusDate: 2003-10-21 21:00:20
Subject: Re: [HACKERS] Mapping Oracle types to PostgreSQL

pgsql-advocacy by date

Next:From: Bruce MomjianDate: 2003-10-21 22:22:52
Subject: Re: [HACKERS] Mapping Oracle types to PostgreSQL types
Previous:From: Josh BerkusDate: 2003-10-21 21:00:20
Subject: Re: [HACKERS] Mapping Oracle types to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group