pgsql: Sort the dependent objects before deletion in DROP OWNED BY.

Started by Tom Laneover 7 years ago1 messagescomitters

tgl@sss.pgh.pa.us

over 7 years ago

Sort the dependent objects before deletion in DROP OWNED BY.

This finishes a task we left undone in commit f1ad067fc, by extending
the delete-in-descending-OID-order rule to deletions triggered by
DROP OWNED BY. We've coped with machine-dependent deletion orders
one time too many, and the new issues caused by Peter G's recent
nbtree hacking seem like the last straw.

Discussion: /messages/by-id/E1h6eep-0001Mw-Vd@gemulon.postgresql.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8aa9dd74b36757342b6208fbfebb5b35c2d67c53

Modified Files
--------------
src/backend/catalog/dependency.c | 17 +++++++++++++++++
src/backend/catalog/pg_shdepend.c | 8 ++++++++
src/include/catalog/dependency.h | 2 ++
3 files changed, 27 insertions(+)