Re: DBMS_File Equivalent? - Mailing list pgsql-general

From Tom Lane
Subject Re: DBMS_File Equivalent?
Date
Msg-id 19509.1105042984@sss.pgh.pa.us
Whole thread Raw
In response to DBMS_File Equivalent?  (Dunc <postgresql@dunc-it.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: DBMS_File Equivalent?
Next
From: Ronnie Meier Ramos
Date:
Subject: Global/persistent variables