On Fri, May 04, 2001 at 09:16:12AM -0700, Stephan Szabo wrote:
>
> 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.
Thanks for the suggestion. I will
investigate further along the line of writing
the trigger in C. But at this point I
am leaning towards sticking to my current
routine which has worked flawlessly
for many months. The reason I need
some 'trigger' is it's a huge mess
to maintain when it does come to the
time to maintain. Right now I'm moving this scheme
to a different set of hardware and it's
quite a nightmare to juggle so many programs
at once while keeping everything running.
It _is_ quite trivial to write a safe perl
trigger especially because I control both client
and server end of postgres. With C it
will be whole new game for me.