Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DE1579FA550 for ; Wed, 29 Aug 2007 13:48:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 43427-10 for ; Wed, 29 Aug 2007 13:47:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 1EA329FA56E for ; Wed, 29 Aug 2007 13:47:57 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l7TGltdF005791; Wed, 29 Aug 2007 12:47:55 -0400 (EDT) To: "Medi Montaseri" cc: "Scott Marlowe" , qinghuamail-postgresqlfans@yahoo.com, postgresql-admin Subject: Re: how to create dir using pg/plsql In-reply-to: <8078a1730708290928t63620ae2h9cd3262edc40e0fe@mail.gmail.com> References: <715958.65839.qm@web58103.mail.re3.yahoo.com> <8078a1730708290928t63620ae2h9cd3262edc40e0fe@mail.gmail.com> Comments: In-reply-to "Medi Montaseri" message dated "Wed, 29 Aug 2007 09:28:25 -0700" Date: Wed, 29 Aug 2007 12:47:55 -0400 Message-ID: <5790.1188406075@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/398 X-Sequence-Number: 26729 "Medi Montaseri" 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 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. Well, sure. Postgres calls those untrusted languages, and only lets database superusers use them. regards, tom lane