[HACKERS] plpgsql cant to set role from function. is bug?

2006-04-28 Thread Pavel Stehule
Hello This code run without error, but do nothing drop role x; create role x; create or replace function foo() returns void as $$ begin grant root to x; end; $$ language plpgsql; \dg x revoke root from x; postgres=# postgres=# DROP ROLE postgres=# CREATE ROLE postgres=# postgres$# postgres$#

[HACKERS] plpgsql cant to set role from function. is bug?, SOLVED

2006-04-28 Thread Pavel Stehule
Hello I am stupid. 1) I don't call function. I am sorry Regards Pavel Stehule _ Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/ ---(end of broadcast)--- TIP