I'm also wondering about what side-effects this will have on pg_dump behavior. In particular, will pg_dump try to "ALTER OWNER public", and if so will that be appropriate? We haven't previously needed to assume that we are restoring into a database with the same datowner as we dumped from...
In my batch of pg_dump patches that have gone in, pg_dump will now do exactly that. The reason was so that if someone altered the owner of their public schema, it should be dumped like that.
Chris
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
