Re: How to execute 'set session role' from plpgsql function?

From: Oleg Vasylenko <pulp(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to execute 'set session role' from plpgsql function?
Date: 2008-08-17 18:02:24
Message-ID: E1KUma8-000B58-00.pulp-mail-ru@f213.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks. You suggestion helped me to find a solution!

DECLARE
...
query text;
BEGIN
....
query := query :='SET SESSION ROLE ' || wishedrole;
EXECUTE query;
......

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Koterov 2008-08-17 18:03:58 Open source PostgreSQL type parsers in PHP?
Previous Message Roderick A. Anderson 2008-08-17 17:42:30 Re: [Q] DNS(bind) ER model