The current SET SESSION AUTHORIZATION is very good feature. Whatallows 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@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz