* Do we no longer worry about the SCHEMA AUTHORIZATION clause? I might set it to keep being issued in 'sql standard mode', but otherwise we cannot use it in dumps any more.

Actually, that's not true - I'm being silly. We can use the AUTHORIZATION clause instead of ALTER SCHEMA ... OWNER TO :)


Another question:

We currently fully qualify DROP command with the namespace so that drops will not accidentally modify the system catalogs. Shouldn't this also be necessary on ALL non-CREATE commands?

ie. All ALTER, GRANT and REVOKE commands?

Otherwise, if the create table command associated with each of these fails (for whatever reason), the script could happily carry on and modify the system catalog tables?

Chris


---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to