On Thu, 3 May 2001 newsreader(at)mediaone(dot)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.