Re: Prevent accidental whole-table DELETEs and UPDATEs

2023-02-02 Thread Tom Lane
Nikolay Samokhvalov writes: > In many cases, a DELETE or UPDATE not having a WHERE clause (or having it > with a condition matching all rows in the table) is a sign of some kind of > mistake, leading to accidental data loss, performance issues, producing a > lot of dead tuples, and so on. Recently

Prevent accidental whole-table DELETEs and UPDATEs

2023-02-02 Thread Nikolay Samokhvalov
In many cases, a DELETE or UPDATE not having a WHERE clause (or having it with a condition matching all rows in the table) is a sign of some kind of mistake, leading to accidental data loss, performance issues, producing a lot of dead tuples, and so on. Recently, this topic was again discussed [1]