Re: Update aborted if trigger function fails?

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Update aborted if trigger function fails?
Date: 2005-04-12 15:17:21
Message-ID: 20050412151721.GA4291@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Apr 12, 2005 at 10:55:30AM -0400, Carlos Moreno wrote:
>
> I guess the concern came up as result of a particular
> situation, in which failing to properly process the
> trigger function is not that crucial (I wanted to
> update some additional information that is "optional",
> and that can be reconstructed easily after discovering
> that the trigger function had been failing). But in

If you can do some things asynchronously, and you don't care about
them very much, then you can use LISTEN/NOTIFY to do such processing.

A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dan Feiveson 2005-04-12 15:18:56 Re: Query runs very slowly in Postgres, but very fast in other DBMS
Previous Message Carlos Moreno 2005-04-12 14:55:30 Re: Update aborted if trigger function fails?