Dunc <postgresql@dunc-it.com> writes:
> Can a trigger, written in plperl, write to the OS when it fires?
No, but a plperlu trigger can.
> My database (8 rc 3, on Redhat
> 9) seems to choke (terminated on signal 11) each time I try to write to
> the OS - I would imagine because it's a major security threat to have
> the DB blindly writing to the filesystem.
It is a security hole, but sig 11 is not the expected response :-(.
Can you provide a debugger backtrace from the crash, or even better a
complete test case? What Perl version are you using?
regards, tom lane