Re: on connect/on disconnect

Robert Edwards <bob@cs.anu.edu.au> writes:

> Or is it possible, over the same connection, to change the database
> user? My understanding of the frontend/backend protocol is that this
> is not allowed.

It is possible to change users.  

SET SESSION AUTHORIZATION <username>;

http://www.postgresql.org/docs/8.1/interactive/sql-set-session-authorization.html


Also just for completeness: http://www.securityfocus.com/bid/16650/info


-- 
Jorge Godoy      <jgodoy@gmail.com>