3 ms·
> –i-am-a-dummy mode The safeupdate postgres extension[1] does this exactly. safeupdate is a simple extension to PostgreSQL that raises an error if UPDATE and
by steve-chavez 4y ago
> –i-am-a-dummy mode
The safeupdate postgres extension[1] does this exactly.
safeupdate is a simple extension to PostgreSQL that raises an error if UPDATE and DELETE are executed without specifying conditions
[1]: https://github.com/eradman/pg-safeupdate https://github.com/eradman/pg-safeupdate
- zX41ZdbW 4y agoI'd like to emphasize the importance of built-in protection from human and configuration errors. For example, if you are trying to drop a table of large enough size, ClickHouse will ask to defuse the protection first: https://clickhouse.com/docs/en/operations/server-configuration-parameters/settings/#max-table-size-to-drop https://clickhouse.com/docs/en/operations/server-configurati...