X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2A134D7DDB for ; Wed, 12 Oct 2005 10:11:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01817-03 for ; Wed, 12 Oct 2005 13:11:23 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.207]) by svr1.postgresql.org (Postfix) with ESMTP id 6C6EBD7D63 for ; Wed, 12 Oct 2005 10:11:25 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id z31so103278nzd for ; Wed, 12 Oct 2005 06:11:29 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=HMo7eUgZ+zWplWgYcfzmLSWWbcwBhev0w3dsSYN0BcuzLFdtGF9shPILZ9EOqX8RUL8KOIViNqIh2MH0yrkuhiw6U2EBC7fBR4uz/k9c912LXmwpX/MQhc7es3j6lja2gb/efz75IJQRiQwOZcBR6cRuSbYQ2RfIpC3u8iF18EY= Received: by 10.37.2.27 with SMTP id e27mr881123nzi; Wed, 12 Oct 2005 06:11:29 -0700 (PDT) Received: by 10.36.227.78 with HTTP; Wed, 12 Oct 2005 06:11:29 -0700 (PDT) Message-ID: <454310280510120611t12e8b975n5e2b9fc188a5bd94@mail.gmail.com> Date: Wed, 12 Oct 2005 09:11:29 -0400 From: Leodan Vega Izaguirre To: pgsql-php@postgresql.org Subject: Re: Set Privileges on All Tables - Wrong List - Sorry In-Reply-To: <20051007172105.95428.qmail@web33306.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20051007165518.67295.qmail@web33307.mail.mud.yahoo.com> <20051007172105.95428.qmail@web33306.mail.mud.yahoo.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 required=5 tests=[RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200510/21 X-Sequence-Number: 3289 Hi, I'm making a function in pgsql to create and delete an user from the database, but in all the variant, I found an error. A simple example is create function DeleteUser (varchar) returns void as ' declare login alias for $1; begin drop user login; end ' language 'plpgsql' But always give an error. We can't manipulate roles in any function of pgsq= l? Sorry for my english and the question, but I'm a student yet!