Re: Need A Suggestion - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Need A Suggestion
Date
Msg-id 434B1942.1070604@familyhealth.com.au
Whole thread Raw
In response to Re: Need A Suggestion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Whether this is a good idea is another question entirely.  Lots of
> people will tell you it's a horrid idea for PG functions to cause
> outside-the-database side effects.  The reason is that if the
> transaction that called the function aborts later, there is no way
> to roll back what was done outside the database, and so the state
> outside the database will no longer be in sync with the state inside.

The new solution for this is to use an XA transaction manager and 2PC I 
guess...

Chris



pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: Need A Suggestion
Next
From: Christopher Kings-Lynne
Date:
Subject: MySQL XA (Was Re: Need A Suggestion)