Re: 'SET LOCAL ROLE blah;' doesn't work?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 'SET LOCAL ROLE blah;' doesn't work?
Date: 2007-06-28 18:41:28
Message-ID: 17572.1183056088@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Stephen Frost <sfrost(at)snowman(dot)net> writes:
> At http://www.postgresql.org/docs/8.2/static/sql-set-role.html, we
> claim that 'SESSION and LOCAL modifiers act the same as for the
> regular SET command', but I don't think that's actually right...

I cannot duplicate the behavior you show, in either HEAD or 8.2.
Are you *sure* you were inside a transaction block?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Arpi 2007-06-28 20:54:34 Re: BUG #3034: FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied
Previous Message Stephen Frost 2007-06-28 17:01:44 'SET LOCAL ROLE blah;' doesn't work?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-06-28 19:09:38 Re: write past chunk end in ExprContext / to_char
Previous Message Alvaro Herrera 2007-06-28 18:29:12 Re: write past chunk end in ExprContext / to_char