safeupdate 1.0.0

This Release
safeupdate 1.0.0
Date
Status
Stable
Latest Stable
safeupdate 1.4.2 —
Other Releases
Abstract
Require criteria for UPDATE and DELETE
Description
A simple extension to PostgreSQL that raises an error ifUPDATE and DELETE are executed without specifying conditions
Released By
eradman
License
MIT
Resources
Special Files
Tags

Extensions

safeupdate 1.0.0
Require criteria for UPDATE and DELETE

README

Require SQL Where Clause

safeupdate is a simple extension to PostgreSQL that raises an error if UPDATE and DELETE are executed without specifying conditions. This extension was initially designed to protect data from accidental obliteration of data that is writable by PostgREST.

Installation

gmake
gmake install

Activate per-session by running

load 'safeupdate';

Make this mandatory for all databases and connections by adding the following to postgresql.conf:

:::ini
shared_preload_libraries=safeupdate

Examples

Try to update records without WHERE clause

:::sql
UPDATE FROM rack SET fan_spee=70;
-- ERROR:  UPDATE requires a WHERE clause

Set a column value for a range of records

:::sql
UPDATE rack SET fan_speed=90 WHERE fan_speed=70;

Set a column value for all the records in a table

:::sql
UPDATE rack SET fan_speed=90 WHERE 1=1;

Requirements

  • PostgreSQL 8.4+

News

A release history as well as features in the upcoming release are covered in the NEWS file.

License

Source is under and ISC-style license. See the LICENSE file for more detailed information on the license used for compatibility libraries.