Problem with function-arguments
| От | Hans Peter Ertz |
|---|---|
| Тема | Problem with function-arguments |
| Дата | |
| Msg-id | 49F22FA1.4020000@gmx.net обсуждение исходный текст |
| Ответы |
Re: Problem with function-arguments
|
| Список | 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
В списке pgsql-admin по дате отправления: