Search Postgresql Archives

Re: stored function (possible to access file system or call java program)?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Oct 3, 2011 at 2:05 PM, J.V. <jvsrvcs@xxxxxxxxx> wrote:
> Is it possible within a stored function to:
>    1) Access the file system (to rename a file for example)
>    2) Call a java program
>
For both of these:
1)  yes, if you use an untrusted program and
2)  These are dangerous because they are operations that exist outside
the transactional control of the RDBMS, so it's usually better to look
to other ways of doing this, like NOTIFY and LISTEN.....

Best Wishes,
Chris Travers

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux