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