COMMIT TRIGGER implementation using CONSTRAINT TRIGGERs

From: Nico Williams <nico(at)cryptonector(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: COMMIT TRIGGER implementation using CONSTRAINT TRIGGERs
Date: 2017-09-14 19:45:36
Message-ID: 20170914194535.GB4487@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've written an approximation of "commit triggers" for PostgreSQL using
CONSTRAINT TRIGGERs (as users have often been told to do who want this
feature).

Semantics (and a warning) are included in commentary in the source:

https://github.com/twosigma/postgresql-contrib/
https://github.com/twosigma/postgresql-contrib/blob/master/commit_trigger.sql
https://raw.githubusercontent.com/twosigma/postgresql-contrib/master/commit_trigger.sql

I suspect a number of users here may find this useful.

I've also posted separately to pgsql-hackers to see if we can get
agreement that commit triggers are a reasonable and desirable feature.

Cheers,

Nico
--

Browse pgsql-general by date

  From Date Subject
Next Message Rafal Pietrak 2017-09-14 20:39:49 Re: looking for a globally unique row ID
Previous Message Kenneth Marshall 2017-09-14 18:15:34 Re: looking for a globally unique row ID