Re: What order of steps of the postgres when you change information in the table?

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Denis Feklushkin <denis(dot)feklushkin(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: What order of steps of the postgres when you change information in the table?
Date: 2009-11-01 07:04:16
Message-ID: 4AED32F0.8010006@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephan Szabo wrote:

> However, I don't think you can currently have both the property that you
> will never have a failure to commit after your external action runs and
> that your external action can abort the transaction if the external action
> fails.

Yeah. That's what two-phase commit is for - but I don't see how you
could use it in a trigger.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gaini Rajeshwar 2009-11-01 08:50:29 Handling Complex queries in PostgreSQL fulltext search
Previous Message Lew 2009-11-01 00:37:19 Re: Absolute value of intervals