Postgres Pro
Downloads
Home   >   mailing lists

Re: 'SET LOCAL ROLE blah;' doesn't work? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: 'SET LOCAL ROLE blah;' doesn't work?
Date
Msg-id 17572.1183056088@sss.pgh.pa.us
Whole thread Raw
In response to 'SET LOCAL ROLE blah;' doesn't work?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: 'SET LOCAL ROLE blah;' doesn't work?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-bugs
Tree view 
Stephen Frost <sfrost@snowman.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

pgsql-bugs by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: BUG #3415: plperl spi_exec_prepared variable undef value confusion
Next
From: Arpi
Date:
Subject: Re: BUG #3034: FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied