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 по дате отправления: