By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,773 Members | 1,724 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,773 IT Pros & Developers. It's quick & easy.

Embedded transactions

P: n/a
On this page: http://www.compiere.org/technology/independence.html, the
project leader of Compiere (a popular ERP package) states that the move to
Postgres failed because of lack of support of embedded
transactions...something both Oracle and DB2 support.

Can someone explain to me excactly what embedded transactions are and why
they're challenging enough to not be included in Postgres or MySQL? I'm
guessing it's some sort of begin/commit/rollback transactions within
being/commit/rollback blocks, but I may be trivializing it.

Thanks,
John
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
John Wells wrote:
On this page: http://www.compiere.org/technology/independence.html, the
project leader of Compiere (a popular ERP package) states that the move to
Postgres failed because of lack of support of embedded
transactions...something both Oracle and DB2 support.

Can someone explain to me excactly what embedded transactions are and why
they're challenging enough to not be included in Postgres or MySQL? I'm
guessing it's some sort of begin/commit/rollback transactions within
being/commit/rollback blocks, but I may be trivializing it.


They want:

BEGIN;
INSERT
BEGIN;
INSERT;
-- failure
ROLLBACK;
INSERT;
COMMIT;

so if the insert fails, they can continue with their transactions. They
are kind of hard to do, but we are working on it:

http://momjian.postgresql.org/main/w.../pgsql/project

--
Bruce Momjian | http://candle.pha.pa.us
pg***@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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.