Tom, > The main objection to this is that it makes the dump completely > unportable.
That's a powerful argument. Dennis and I are hashing this out on IRC. The second option would be to simply put SET SESSION AUTHORIZATION statements before each and every statement in the pg_dump. This would make each statement "atomic" as far as user ownership is concerned, with less changes than "WITH OWNER" would entail. I can't imagine that it would slow down restoring much, and could even be helped by making SET SESSION AUTHORIZATION realize it didn't have to do anything if that was already the current user (does it now?). > Not in 8.0. Of course not. I'm talking for 8.1, or later. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster