Re: [ADMIN] how to create dir using pg/plsql

2007-08-29 Thread Alvaro Herrera
Medi Montaseri escribió: > I see...thank you for the clarification...one more question... > How does PG protects itself from a run-away code (eg an endless loop) ? It doesn't. > In other words, does PG run the "untrusted" code in a seperate > process? No. -- Alvaro Herrera

Re: [ADMIN] how to create dir using pg/plsql

2007-08-29 Thread Medi Montaseri
I see...thank you for the clarification...one more question... How does PG protects itself from a run-away code (eg an endless loop) ? In other words, does PG run the "untrusted" code in a seperate process? Thanks Medi On 8/29/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > "Medi Montaseri" <[EMAIL P

Re: [ADMIN] how to create dir using pg/plsql

2007-08-29 Thread Tom Lane
"Medi Montaseri" <[EMAIL PROTECTED]> writes: > I was under the impression that recent modern databases, like PG, allow you > to transfer control to an out-of-system (system being the DB engine) module > (shared lib, dll). That is while triggers transfer control within the > system, now mechanisms

Re: [ADMIN] how to create dir using pg/plsql

2007-08-29 Thread Medi Montaseri
I was under the impression that recent modern databases, like PG, allow you to transfer control to an out-of-system (system being the DB engine) module (shared lib, dll). That is while triggers transfer control within the system, now mechanisms exists that allow you to go outside of the system. In

Re: [ADMIN] how to create dir using pg/plsql

2007-08-29 Thread Scott Marlowe
On 8/29/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > just subject, > > i need to create dir using pg/plsql function,,but cannt get anything after > google, As noted, not possible. BUT, you can do it in untrusted languages, like pl/perlu or pl/tclu or pl/C ---(end of

回复: Re: [ADMIN] how to create dir using pg/plsql

2007-08-29 Thread qinghuamail-postgresqlfans
oh,i see, thank you very much! hubert depesz lubaczewski <[EMAIL PROTECTED]> 写道: On Wed, Aug 29, 2007 at 02:45:56PM +0800, [EMAIL PROTECTED] wrote: > just subject, > i need to create dir using pg/plsql function,,but cannt get anything after > google, it's not possible. pl/pgsql is trusted langu

Re: [ADMIN] how to create dir using pg/plsql

2007-08-29 Thread hubert depesz lubaczewski
On Wed, Aug 29, 2007 at 02:45:56PM +0800, [EMAIL PROTECTED] wrote: > just subject, > i need to create dir using pg/plsql function,,but cannt get anything after > google, it's not possible. pl/pgsql is trusted language (like pl/perl and pl/tcl). trusted languages cannot use system-level functions.

[ADMIN] how to create dir using pg/plsql

2007-08-28 Thread qinghuamail-postgresqlfans
just subject, i need to create dir using pg/plsql function,,but cannt get anything after google, please advise? thanks! - 雅虎邮箱,以安全著称,是值得信赖的邮箱专家!