Re: a primer on trigger?

On Thu, 3 May 2001 newsreader@mediaone.net wrote:

> What I want to do is "trigger" a
> system call when a table is modified
> in any way.  But it appears
> that trigger idea in postgres
> is not capable.  Can any one
> confirm if that is the case?

I believe you can make syscalls if you
write a trigger in C (rather than one
of the procedural languages).

However (and it's a big one), you should
only ever consider modifying something outside
of the database from a trigger if it's
something that is absolutely safe to do
if the transaction rolls back.