Re: [GENERAL] PostgreSQL XA ?

2005-05-17 Thread Kris Jurka 


On Tue, 17 May 2005, FERREIRA, William (COFRAMI) wrote:

 hi at present my j2ee application use an Oracle database with XA
 transactions. i'm migrating Oracle to PostgreSQL, and i'm looking for a
 XA driver for PostgreSQL. does it exist ?
  

No, postgresql does not support distributed transactions, so it does not 
have XA JDBC support.

Kris Jurka

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [GENERAL] PostgreSQL XA ?

2005-05-17 Thread Bruno Wolff III 
On Tue, May 17, 2005 at 14:05:46 -0500,
  Kris Jurka [EMAIL PROTECTED] wrote:
 
 
 On Tue, 17 May 2005, FERREIRA, William (COFRAMI) wrote:
 
  hi at present my j2ee application use an Oracle database with XA
  transactions. i'm migrating Oracle to PostgreSQL, and i'm looking for a
  XA driver for PostgreSQL. does it exist ?
   
 
 No, postgresql does not support distributed transactions, so it does not 
 have XA JDBC support.

I think someone is working on 2PC for 8.1 which would provide infrastructure
for this.

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