| From: | "Yotsunaga, Naoki" <yotsunaga(dot)naoki(at)jp(dot)fujitsu(dot)com> |
|---|---|
| To: | 'Jaime Casanova' <jaime(dot)casanova(at)2ndquadrant(dot)com> |
| Cc: | "david(dot)g(dot)johnston(at)gmail(dot)com" <david(dot)g(dot)johnston(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, "michael(at)paquier(dot)xyz" <michael(at)paquier(dot)xyz> |
| Subject: | RE: automatic restore point |
| Date: | 2018-07-06 08:10:44 |
| Message-ID: | 8E9126CB6CE2CD42962059AB0FBF7B0DBF49A5@g01jpexmbkw23 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>-----Original Message-----
>From: Jaime Casanova [mailto:jaime(dot)casanova(at)2ndquadrant(dot)com]
>Sent: Tuesday, July 3, 2018 11:06 AM
>Thinking on Michael's suggestion of using event triggers, you can create an event >trigger to run pg_create_restore_point() on DROP, here's a simple example of how >that should like:
>https://www.postgresql.org/docs/current/static/functions-event-triggers.html
>You can also create a normal trigger BEFORE TRUNCATE to create a restore point just >before running the TRUNCATE command.
Thanks for comments.
I was able to understand.
---
Naoki Yotsunaga
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles Clavadetscher | 2018-07-06 08:19:57 | RE: How to remove elements from array . |
| Previous Message | Yotsunaga, Naoki | 2018-07-06 08:05:03 | RE: automatic restore point |