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
