Re: COMMIT TRIGGERs, take n, implemented with CONSTRAINT TRIGGERS

From: Andres Freund <andres(at)anarazel(dot)de>
To: Nico Williams <nico(at)cryptonector(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: COMMIT TRIGGERs, take n, implemented with CONSTRAINT TRIGGERS
Date: 2017-09-15 18:26:08
Message-ID: 20170915182608.qi7bi3zwhuz3j4nv@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2017-09-14 14:41:12 -0500, Nico Williams wrote:
> I've read through several old threads on COMMIT TRIGGERs. Rather than
> write a lengthy post addressing past debates, here's an implementation
> and demonstration of [an approximation of] COMMIT TRIGGERs with natural
> and _desirable_ semantics:

I think you should also explain why that's a desirable set of
semantics. E.g. explain the use case you have and potential other
use-cases. I think it should also be explained that these are
*pre*-commit triggers - IIRC some people have asked for *post*-commit
triggers in the past.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2017-09-15 18:32:37 Re: Patch: add --if-exists to pg_recvlogical
Previous Message Andres Freund 2017-09-15 18:23:11 Re: SendRowDescriptionMessage() is slow for queries with a lot of columns