The current SET SESSION AUTHORIZATION is very good feature. What
allows it to standard users too. For example by:
SET SESSION AUTHORIZATION 'username' WITH PASSWORD 'pwd';
Why? Because change identity is less expensive than reconnection.
Karel
--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz