Обсуждение: Does anyone know what "embedded transactions" are?

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

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

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

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

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