ERROR: cannot drop objects owned by role postgres because they are required by the database system

[TEST REPORT]

[Release]: 9.0beta1

[Test Type]: psql CLI

[Test]: Trying to perform basic change ownership operations using psql; percursor to dropping the postgres role.

[Platform]: Solaris SPARC 4u (E450)

[Parameters]: Objective: replace postgres user with 'admin', then drop 'postgres'. First, trying to change ownerships of system objects...

postgres=# ALTER ROLE admin CREATEDB CREATEROLE LOGIN ENCRYPTED PASSWORD '<pword>';

postgres=# REASSIGN OWNED BY postgres TO admin;

- ERROR: cannot drop objects owned by role postgres because they are required by the database system

postgres=# ALTER DATABASE postgres OWNER TO admin;

postgres=# REASSIGN OWNED BY postgres TO admin;

- ERROR: cannot drop objects owned by role postgres because they are required by the database system

postgres=# \c postgres admin

- You are now connected to database "postgres" as user "admin".

postgres=# DROP role postgres;

- ERROR: cannot drop role postgres because it is required by the database system (Makes sense!)

postgres=# REASSIGN OWNED BY postgres TO admin;

- ERROR: cannot drop objects owned by role postgres because they are required by the database system

[Failure]: Dunno?

[Results]:

postgres=# REASSIGN OWNED BY postgres TO admin;

- ERROR: cannot drop objects owned by role postgres because they are required by the database system

[Comments]: Should we be able to get rid of the postgres user 'elegantly'? Is there a way to REASSIGN without DROPping? Perhaps new design precludes this? Documentation opportunity?