Hi guys,

Was just looking at the project page for Compiere, an Open Source
ERP+CRM solution that is usually in the top 10 most popular SourceForge
projects.

They were attempting to port Compiere from Oracle to PostgreSQL, but
have stopped (apparently) because PostgreSQL doesn't support "embedded
transations".

http://www.compiere.org/technology/independence.html

Does anyone know what they're talking about?

:-)

Regards and best wishes,

Justin Clift

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi

Mon, 02 Dec 2002 08:42:47 +1100
Justin Clift <justin@postgresql.org>
Does anyone know what "embedded transactions" are?
Justin Clift wrote:
> Hi guys,
> 
> Was just looking at the project page for Compiere, an Open Source
> ERP+CRM solution that is usually in the top 10 most popular SourceForge
> projects.
> 
> They were attempting to port Compiere from Oracle to PostgreSQL, but
> have stopped (apparently) because PostgreSQL doesn't support "embedded
> transations".
> 
> http://www.compiere.org/technology/independence.html
> 
> Does anyone know what they're talking about?

I assume it is:

	BEGIN;
	...
	BEGIN;
	...
	COMMIT;
	COMMIT;

That thing I am trying to do for 7.4.

-- 
  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

Sun, 1 Dec 2002 17:44:56 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Does anyone know what "embedded transactions" are?
Bruce Momjian wrote:
> Justin Clift wrote:
> 
>>Hi guys,
>>
>>Was just looking at the project page for Compiere, an Open Source
>>ERP+CRM solution that is usually in the top 10 most popular SourceForge
>>projects.
>>
>>They were attempting to port Compiere from Oracle to PostgreSQL, but
>>have stopped (apparently) because PostgreSQL doesn't support "embedded
>>transations".
>>

Has anyone from Compiere ever contacted this list to discuss their issues? It 
is an unbelievable shame that the most active open source ERP can't use an 
open source database.

Joe



Sun, 01 Dec 2002 15:01:50 -0800
Joe Conway <mail@joeconway.com>
Re: Does anyone know what "embedded transactions" are?
Joe Conway wrote:
> 
<snip>
> Has anyone from Compiere ever contacted this list to discuss their issues? It
> is an unbelievable shame that the most active open source ERP can't use an
> open source database.

I think so, but not with zeal.

:-/

Regards and best wishes,

Justin Clift

 
> Joe

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi

Mon, 02 Dec 2002 10:19:30 +1100
Justin Clift <justin@postgresql.org>
Re: Does anyone know what "embedded transactions" are?
Reading through their web page, they seem to have decided to try and 
fund moving their transactional issues into the Java container instead 
of getting nested transactions into PostgreSQL. It sounds retrograde and 
risky, but I suppose if they carry it off, they will attain true 
database independance.

Joe Conway wrote:
> 
> Has anyone from Compiere ever contacted this list to discuss their 
> issues? It is an unbelievable shame that the most active open source ERP 
> can't use an open source database.
> 



Sun, 01 Dec 2002 17:36:53 -0800
Paul Ramsey <pramsey@refractions.net>
Re: Does anyone know what "embedded transactions" are?