Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 28 Jun 2007 14:41:28 -0400
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
- Follow-Ups:
- Re: 'SET LOCAL ROLE blah;' doesn't work?
- From: Stephen Frost
- Re: 'SET LOCAL ROLE blah;' doesn't work?
- References:
- 'SET LOCAL ROLE blah;' doesn't work?
- From: Stephen Frost
- 'SET LOCAL ROLE blah;' doesn't work?
- Prev by Date: 'SET LOCAL ROLE blah;' doesn't work?
- Next by Date: Re: BUG #3034: FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied
- Previous by thread: 'SET LOCAL ROLE blah;' doesn't work?
- Next by thread: Re: 'SET LOCAL ROLE blah;' doesn't work?
- Indexes: