Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Then I made it so that pg_dump will output an OWNER TO statement after
> every object creation.
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 would envision the safest procedure as creating all objects, loading
all data, etc, then all ALTER OWNERs, then all GRANT/REVOKEs.
> * Do we need the set session auth for COPY commands still?
Not if you still own the table while loading into it (see above point).
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.
> * Is there any reason there is no RENAME TO command for operators?
Lack of round tuits, no doubt.
regards, tom lane