Problem with function-arguments

From: Hans Peter Ertz <hansi_mailinglisten(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem with function-arguments
Date: 2009-04-24 21:31:13
Message-ID: 49F22FA1.4020000@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello everyone!

First of all: I'm using Postgres 8.2.4 on a WinXP machine.

I'm trying to create a function that creates a new user-role to allow
non-super-users to create users.

The function should look something like that (well, obviously it should
not...but it's to give you an idea, what I'm talking about):

CREATE OR REPLACE FUNCTION sys.create_user(text, text)
RETURNS void AS
$BODY$
CREATE ROLE "$1" LOGIN PASSWORD '$2' INHERIT NOCREATEDB CREATEROLE;
$BODY$
LANGUAGE 'sql' VOLATILE SECURITY DEFINER;

The statement "SELECT sys.create_user('myusername', 'mypassword'); "
creates a user named $1 with password $2.......well....that's not whwat
I want the function to do.....

Nearly any combination of double-quotes, single-quotes leads to a
syntax-error when trying to create the function...

At the moment I'm running out of ideas...can anyone help?

Greetings and TIA,
Hans Peter Ertz

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Hans Peter Ertz 2009-04-24 23:17:04 Re: Problem with function-arguments
Previous Message Ries van Twisk 2009-04-24 21:12:00 Re: Deleting "parent" record