Hi all,
I have the following function:
create function new_student (text) returns text as $$
declare
wtf integer := 1;
begin
execute 'create schema ' || $1;
execute 'create role ' || $1 || 'LOGIN';
execute 'revoke all on schema public from
am Fri, dem 14.03.2008, um 10:00:05 -0700 mailte Webb Sprague folgendes:
Hi all,
I have the following function:
create function new_student (text) returns text as $$
declare
wtf integer := 1;
begin
execute 'create schema ' || $1;
execute
Webb Sprague [EMAIL PROTECTED] writes:
execute 'create role ' || $1 || 'LOGIN';
I think you're short one crucial space ...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription: