Bruce McAlister wrote: > Denis Gasparin wrote: > > RESET SESSION command is available only in 8.2 branch, isn't it? > > I tried to issue the command in a 8.1 server and the answer was: ERROR: > > unrecognized configuration parameter "session" > > I had a look in our configuration and there is a "session" option that > comes up if you type "RESET " and press TAB twice. However, if you do > try to run it, it comes back with: > > blueface-crm=# RESET session ; > ERROR: unrecognized configuration parameter "session" If you continue tab-completing you'll notice that it's actually "reset session authorization" which is a different animal completely. > We're running PostgreSQL 8.2.4. Alvaro said it was only going to be > available in 8.3. I hope they backport it to 8.2 though, No way. > 90% of our connections are via connection pooled drivers, so being > able to reset the session after each transaction would be a handy way > to ensure the environment is sane for the next transaction :) Seems you'll be one of the early adopters of 8.3 solely for this reason ;-) -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
