I wrote:
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
In thinking about this I'm wondering if I'm making this harder then it
needs to be. If I could write a function that builds, and returns the
RSS file that would accomplish what I want - assuming that I could call
the function from a webpage. Can Postgres functions be called from a
URL, similar to how PL/SQL files can be in Oracle?
Dunc
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
