Hello again!
Problem solved!
I switched my language to plpgsql and used the execute-command. The
function now looks like:
CREATE OR REPLACE FUNCTION sys.create_user(character varying, character
varying)
RETURNS void AS
$BODY$
BEGIN
execute 'CREATE USER ' || quote_ident($1) || ' PASSWORD ' ||
quote_literal($2) || ' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE';
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER;
Nevertheless - thanks for thinking ;-),
Hans Peter Ertz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
