Re: OWNER TO on all objects

> Perhaps better to put these out towards the end of the dump, not right
> after the creation of the object? Or is that what you're doing?

I just inserted the ALTER OWNER statement between the CREATE and the
GRANTs. Why do you want them at the end of the dump?

> I would envision the safest procedure as creating all objects, loading
> all data, etc, then all ALTER OWNERs, then all GRANT/REVOKEs.

I don't yet understand your reasoning for wanting this all at the end...

> Not if you still own the table while loading into it (see above point).

Can we not load as superuser?

> However, this all assumes a complete dump/restore. Consider data-only
> restores. Consider partial restores using pg_restore's options for
> that. What happens then? It'd likely be appropriate to issue set
> session auth during scenarios involving pre-existing objects.

OK, i will test all those situations... What scenarios did you have in
mind?

Chris