PHP with PostgreSQL - Re: Set Privileges on All Tables - Wrong List

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Set Privileges on All Tables - Wrong List - Sorry

Leodan Vega Izaguirre

2005-10-27, 8:14 am

Hi,
I'm making a function in pgsql to create and delete an user from the
database, but in all the variant, I found an error.
A simple example is

create function DeleteUser (varchar) returns void
as '
declare
login alias for $1;
begin
drop user login;
end
'
language 'plpgsql'

But always give an error. We can't manipulate roles in any function of pgsql?
Sorry for my english and the question, but I'm a student yet!

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links