| From: | surya poondla <suryapoondla4(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [DESIGN] Soft DROP TABLE, recoverable drops for PostgreSQL |
| Date: | 2026-07-02 00:55:08 |
| Message-ID: | CAOVWO5oaR_2aFq6mLuedMdQCproi1GTotuhDnECbHBGgfXxr-g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-WIP-pgtrashcan-contrib-extension.patch | application/octet-stream | 343.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2026-07-02 01:05:18 | Re: psql: Fix \df tab completion for procedures |
| Previous Message | Tatsuo Ishii | 2026-07-02 00:48:13 | Re: Row pattern recognition |