Skip site navigation (1) Skip section navigation (2)

"lock tuple" extension

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: pgsql-announce(at)postgresql(dot)org
Subject: "lock tuple" extension
Date: 2012-03-13 07:56:07
Message-ID: alpine.DEB.2.02.1203130844130.2753@localhost6.localdomain6 (view raw, whole thread or download thread mbox)
Lists: pgsql-announce

Some time ago, I developed a PostgreSQL extension to lock tuples based on 
the value of a boolean attribute. If the lock is on, an exception is 
raised when trying to change the row. The trigger must be disabled in 
order to bypass the protection, which may not be available to a given 

This was done as an exercise to understand how to code a trigger in C, but 
I figured out that it may be useful to some people, so I updated it and 
released it as a free software.


pgsql-announce by date

Next:From: Marko KreenDate: 2012-03-13 09:36:26
Subject: SkyTools 2.1.13
Previous:From: Daniele VarrazzoDate: 2012-03-13 04:13:49
Subject: PGXN Client 1.0.2 released

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group