Re: deferrable triggers

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: deferrable triggers
Date: 2011-12-21 15:07:35
Message-ID: 4EF1A1D70200002500043F32@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> However, it's not a "commit time" trigger exactly -- keep in mind
> that SET CONSTRAINTS can override the trigger's own timing
> specification.

Hmm. Is there a way for trigger code to check whether it is running
deferred (at transaction commit time) versus immediate? (If not, I
see writing a small patch in my future to allow it.)

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2011-12-21 15:19:10 Re: Page Checksums
Previous Message Dimitri Fontaine 2011-12-21 13:55:29 Re: Extensions and 9.2