DBMS_File Equivalent? - Mailing list pgsql-general

From Dunc
Subject DBMS_File Equivalent?
Date
Msg-id 41DD991B.3070004@dunc-it.com
Whole thread Raw
Responses Re: DBMS_File Equivalent?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: DBMS_File Equivalent?  (Dunc <postgresql@dunc-it.com>)
Re: DBMS_File Equivalent?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Can a trigger, written in plperl, write to the OS when it fires?  I want
to write a trigger, in plperl, that builds an RSS feed file with each
row that gets added to one of my tables.  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.  I guess what I really need is
something like dbms_file in Oracle, where one predefines where the DB is
allowed to read and write files.  Can this be done with Postgres?

Dunc

pgsql-general by date:

Previous
From: Doseok Kim
Date:
Subject: question about plpythonu
Next
From: "Joshua D. Drake"
Date:
Subject: Re: DBMS_File Equivalent?