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 252A8D1B4CC for ; Sun, 28 Dec 2003 16:23:48 +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 72159-09 for ; Sun, 28 Dec 2003 12:22:59 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id CC0A6D1B437 for ; Sun, 28 Dec 2003 12:22:58 -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 hBSGMp19018347; Sun, 28 Dec 2003 11:22:51 -0500 (EST) To: Oli Sennhauser Cc: pgsql-admin@postgresql.org Subject: Re: CREATE USER system privilege? In-reply-to: <3FEEA56C.6080709@bluewin.ch> References: <3FE6D077.7000403@bluewin.ch> <15986.1072106106@sss.pgh.pa.us> <3FEEA56C.6080709@bluewin.ch> Comments: In-reply-to Oli Sennhauser message dated "Sun, 28 Dec 2003 10:42:04 +0100" Date: Sun, 28 Dec 2003 11:22:51 -0500 Message-ID: <18346.1072628571@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/321 X-Sequence-Number: 11827 Oli Sennhauser writes: >> You need to use EXECUTE to construct this query as a string. > Facit: pgplsql does not work for my problem, execute does not work problem. I didn't think I would have to spell it out in gory detail ... regression=# create or replace function cruser(text) returns void as ' regression'# begin regression'# execute ''CREATE USER '' || quote_ident($1); regression'# return; regression'# end' language plpgsql; CREATE FUNCTION regression=# select cruser('foo'); cruser -------- (1 row) regression=# select cruser('bar'); cruser -------- (1 row) regression=# select usename from pg_user; usename ----------------------- postgres pleb foo bar (5 rows) regression=# regards, tom lane