Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id B29F19F9BD1 for ; Wed, 29 Aug 2007 06:29:01 -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 36311-04 for ; Wed, 29 Aug 2007 06:28:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web58109.mail.re3.yahoo.com (web58109.mail.re3.yahoo.com [68.142.236.132]) by postgresql.org (Postfix) with SMTP id 26EFD9F9B9F for ; Wed, 29 Aug 2007 06:28:57 -0300 (ADT) Received: (qmail 9484 invoked by uid 60001); 29 Aug 2007 09:28:56 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=sBimNzgLdse7xFDC9MPvPXqWimHEVX2CPC4XbIMlXfVp9k2GaVbvE8X1489zNDT64xaPiRpvtArgUehnZom/oKDDZKtOkFrtye+RaX7Bc0SFZGJhqXX7mWQacldp7pzOIngaOMwnb4HL40h9OD9PdvmapDUeoihGGJn6wrhPNQc=; X-YMail-OSG: wRIQvzwVM1k8IIULzCB9IAKeb5seiQLUTNB92JXBf.TffYDh0M1rOd5oONagdll4UQ-- Received: from [219.142.118.227] by web58109.mail.re3.yahoo.com via HTTP; Wed, 29 Aug 2007 17:28:55 CST Date: Wed, 29 Aug 2007 17:28:55 +0800 (CST) From: Reply-To: qinghuamail-postgresqlfans@yahoo.com Subject: =?gb2312?q?=BB=D8=B8=B4=A3=BA=20Re:=20=20how=20to=20create=20dir?= =?gb2312?q?=20using=20pg/plsql?= To: depesz@depesz.com, qinghuamail-postgresqlfans@yahoo.com Cc: postgresql-admin In-Reply-To: <20070829082742.GA19034@depesz.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-155116316-1188379735=:9480" Content-Transfer-Encoding: 8bit Message-ID: <20155.9480.qm@web58109.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.335 tagged_above=0 required=5 tests=AWL=0.333, BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200708/386 X-Sequence-Number: 26717 --0-155116316-1188379735=:9480 Content-Type: text/plain; charset=gb2312 Content-Transfer-Encoding: 8bit oh,i see, thank you very much! hubert depesz lubaczewski 写道: On Wed, Aug 29, 2007 at 02:45:56PM +0800, qinghuamail-postgresqlfans@yahoo.com 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. so no file, directory, socket access is possible. depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) --------------------------------- 雅虎邮箱,以安全著称,是值得信赖的邮箱专家! --0-155116316-1188379735=:9480 Content-Type: text/html; charset=gb2312 Content-Transfer-Encoding: 8bit oh,i see, thank you very much!

hubert depesz lubaczewski <depesz@depesz.com> 写道:
On Wed, Aug 29, 2007 at 02:45:56PM +0800, qinghuamail-postgresqlfans@yahoo.com 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. so no file, directory,
socket access is possible.

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)


雅虎邮箱,以安全著称,是值得信赖的邮箱专家! --0-155116316-1188379735=:9480--