Re: automatic restore point

On Mon, Jun 25, 2018 at 6:17 PM, Yotsunaga, Naoki <
yotsunaga.naoki@jp.fujitsu.com> wrote:

> ​​
> So what do you think about it? Do you think is it useful?
>

​The cost/benefit ratio seems low...​

Also, when recovering with the current specification, tables other than the
> returned table also return to the state of the specified recovery point.
> So, I’m looking for ways to recover only specific tables. Do you have any
> ideas?
>

...and this lowers it even further.
​
I'd rather spend effort making the initial execution of said commands less
likely.  Something like:

TRUNCATE table YES_I_REALLY_WANT_TO_DO_THIS;

which will fail if you don't add the keyword "YES_I..." to the end of the
command and the system was setup to require it.

Or, less annoyingly:

BEGIN;
SET LOCAL perform_dangerous_action = true; --can we require local?
TRUNCATE table;
COMMIT;

David J.
​