"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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce


Hello,

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
user.

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.

http://people.apache.org/~fabien/tuplock/

--
Fabien

Browse pgsql-announce by date

  From Date Subject
Next Message Marko Kreen 2012-03-13 09:36:26 SkyTools 2.1.13
Previous Message Daniele Varrazzo 2012-03-13 04:13:49 PGXN Client 1.0.2 released