Dropping a user could merely set a "dropped" flag to disable login, and some VACUUM action could cleanup databases.How would you know when everything was cleaned up on all the databases?
A quick perusal of dev docs suggests that cleanup would need to take place in the following:
pg_am pg_class pg_conversion pg_group pg_namespace pg_opclass pg_operator pg_proc (and watch for prosecdef) pg_type
cheers
andrew
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster