[GENERAL] Unexpected error in grant/revoke script

2008-03-14 Thread Webb Sprague
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

Re: [GENERAL] Unexpected error in grant/revoke script

2008-03-14 Thread A. Kretschmer
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

Re: [GENERAL] Unexpected error in grant/revoke script

2008-03-14 Thread Tom Lane
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: