Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 0C8909FA536 for ; Wed, 29 Aug 2007 13:28:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 15868-06 for ; Wed, 29 Aug 2007 13:28:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.248]) by postgresql.org (Postfix) with ESMTP id 8E8ED9FA1E3 for ; Wed, 29 Aug 2007 13:28:26 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so48710ana for ; Wed, 29 Aug 2007 09:28:25 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=ajKPGOqZ7CZxlWTEylAPRaTc9sol96p/Ct253LQP3VVh6qXPkxn1463WPt7J9o4HQyvFLGgaO9Ipgnceps7cQlZ0j7ulQ3gxQjHu+YwH6cvIX0fzbyvZYuGxTG+gtJ7WuMLnuLIVVR2InXW25tyHu91MHFm1vwvrdBi40IwsfTY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=HVLKC+M4pgnm/ipPmr+0ERevmM6H5RceHTKl/kYjPEbUr+Q0OAaHau6AqAtm9uvn11LsyixEz1g9XhGOhDAhyKXBwCZ2Yegj2plefoW++dGTB6ulU4Ird55G+BZ8MS3ztfyZ2Xp6sCyPL4kswUOJ0bgjzsCnkW8MWavaTOHX55I= Received: by 10.100.190.8 with SMTP id n8mr763596anf.1188404905192; Wed, 29 Aug 2007 09:28:25 -0700 (PDT) Received: by 10.65.110.15 with HTTP; Wed, 29 Aug 2007 09:28:25 -0700 (PDT) Message-ID: <8078a1730708290928t63620ae2h9cd3262edc40e0fe@mail.gmail.com> Date: Wed, 29 Aug 2007 09:28:25 -0700 From: "Medi Montaseri" To: "Scott Marlowe" Subject: Re: how to create dir using pg/plsql Cc: qinghuamail-postgresqlfans@yahoo.com, postgresql-admin In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2050_26976470.1188404905104" References: <715958.65839.qm@web58103.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/397 X-Sequence-Number: 26728 ------=_Part_2050_26976470.1188404905104 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 that context, whence the control is transferred to a C, Perl or whatever language, who is to stop that function from doing anything it wants. I appreciate a clarification. Medi On 8/29/07, Scott Marlowe wrote: > > On 8/29/07, qinghuamail-postgresqlfans@yahoo.com > 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 broadcast)--------------------------- > TIP 6: explain analyze is your friend > ------=_Part_2050_26976470.1188404905104 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 that context, whence the control is transferred to a C, Perl or whatever language, who is to stop that function from doing anything it wants.

I appreciate a clarification.

Medi

On 8/29/07, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On 8/29/07, qinghuamail-postgresqlfans@yahoo.com
<qinghuamail-postgresqlfans@yahoo.com> 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 broadcast)---------------------------
TIP 6: explain analyze is your friend

------=_Part_2050_26976470.1188404905104--