X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3AA7ED1B491 for ; Mon, 22 Dec 2003 15:15:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 30739-01 for ; Mon, 22 Dec 2003 11:15:08 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 9A7DAD1B4B3 for ; Mon, 22 Dec 2003 11:15:03 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hBMFF619015987; Mon, 22 Dec 2003 10:15:06 -0500 (EST) To: Oli Sennhauser Cc: pgsql-admin@postgresql.org Subject: Re: CREATE USER system privilege? In-reply-to: <3FE6D077.7000403@bluewin.ch> References: <3FE6D077.7000403@bluewin.ch> Comments: In-reply-to Oli Sennhauser message dated "Mon, 22 Dec 2003 12:07:35 +0100" Date: Mon, 22 Dec 2003 10:15:06 -0500 Message-ID: <15986.1072106106@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/297 X-Sequence-Number: 11803 Oli Sennhauser writes: > I wanted to create a user who can create other users. That is a superuser. > --> Why does CREATE USER $1 fail??? You need to use EXECUTE to construct this query as a string. Utility statements in general don't handle parameters. regards, tom lane