[GENERAL] COMMIT TRIGGER implementation using CONSTRAINT TRIGGERs - Mailing list pgsql-general

From Nico Williams
Subject [GENERAL] COMMIT TRIGGER implementation using CONSTRAINT TRIGGERs
Date
Msg-id 20170914194535.GB4487@localhost
Whole thread Raw
List 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
-- 


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: [GENERAL] looking for a globally unique row ID
Next
From: Rafal Pietrak
Date:
Subject: Re: [GENERAL] looking for a globally unique row ID