RE: automatic restore point - Mailing list pgsql-hackers

From Yotsunaga, Naoki
Subject RE: automatic restore point
Date
Msg-id 8E9126CB6CE2CD42962059AB0FBF7B0DBF49A5@g01jpexmbkw23
Whole thread Raw
In response to Re: automatic restore point  (Jaime Casanova <jaime.casanova@2ndquadrant.com>)
List pgsql-hackers
>-----Original Message-----
>From: Jaime Casanova [mailto:jaime.casanova@2ndquadrant.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

pgsql-hackers by date:

Previous
From: "Yotsunaga, Naoki"
Date:
Subject: RE: automatic restore point
Next
From: Yugo Nagata
Date:
Subject: Re: Fix to not check included columns in ANALYZE on indexes