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 4: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

sounds like you should be using pl/sh
(http://plsh.projects.postgresql.org/) or pl/java
(http://pgfoundry.org/projects/pljava/).

just remember, try not to get into situation where your function
blocks indefinitely waiting for called program to exist.  keep it
short and sweet, or spawn the program off and collect the response in
separate transaction.

merlin

-- 
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