Re: [GENERAL] running external programs
On Tuesday 07 November 2006 10:55, km wrote: > > > Is it possible in a PLSQL function to call an external program/script > > > residing at /usr/bin and return the result ? > > > > No, because plsql is a trusted language. > > You can't run external commands from such a language. > > Is that a deciding criteria for a language to be flagged trusted or not ? besides other reasons, yes. UC -- Open Source Solutions 4U, LLC 1618 Kelly St Phone: +1 707 568 3056 Santa Rosa, CA 95401 Cell: +1 650 302 2405 United States Fax:+1 707 568 6416 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] running external programs
> > Is it possible in a PLSQL function to call an external program/script > > residing at /usr/bin and return the result ? > > No, because plsql is a trusted language. > You can't run external commands from such a language. Is that a deciding criteria for a language to be flagged trusted or not ? KM ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] running external programs
km wrote: Hi all, Is it possible in a PLSQL function to call an external program/script residing at /usr/bin and return the result ? are there any workarounds for this sort of a problem ? regards, KM You can do it with a PLperl function. You would have to use the untrusted PLperlu though. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] running external programs
In response to Andreas Kretschmer <[EMAIL PROTECTED]>: > > are there any workarounds for this sort of a problem ? > > Yes, with untrusted languages like plperlU or plsh or other. You can also write your own stored procedures that duplicate the functionality of the external program ... assuming you have that kind of access to the source code of the external program. -- Bill Moran Collaborative Fusion Inc. IMPORTANT: This message contains confidential information and is intended only for the individual named. If the reader of this message is not an intended recipient (or the individual responsible for the delivery of this message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this message is prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] running external programs
km <[EMAIL PROTECTED]> schrieb: > > Hi all, > > Is it possible in a PLSQL function to call an external program/script > residing at /usr/bin and return the result ? No, because plsql is a trusted language. You can't run external commands from such a language. > > are there any workarounds for this sort of a problem ? Yes, with untrusted languages like plperlU or plsh or other. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly."(unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] running external programs
Hi all, Is it possible in a PLSQL function to call an external program/script residing at /usr/bin and return the result ? are there any workarounds for this sort of a problem ? regards, KM ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster