Re: DBMS_File Equivalent?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dunc <postgresql(at)dunc-it(dot)com>
Cc: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: DBMS_File Equivalent?
Date: 2005-01-06 20:23:04
Message-ID: 19509.1105042984@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dunc <postgresql(at)dunc-it(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ronnie Meier Ramos 2005-01-06 20:32:20 Global/persistent variables
Previous Message Ragnar Hafstað 2005-01-06 20:20:16 Re: Query, view join question.