Hi All,
I'm posting a WIP patch for the above design.
The patch adds contrib/pgtrashcan: a new extension that intercepts DROP
TABLE via a ProcessUtility hook and moves the relation to a
reserved schema instead of destroying it, from where it can be restored
with pgtrashcan_restore or permanently deleted with
pgtrashcan_purge. It is a fork of an existing pgtrashcan extension,
extended with additional features.
Any feedback is welcome.
Regards,
Surya Poondla