Skip to content

Instantly share code, notes, and snippets.

@patmaddox

patmaddox/no_delete.sql

Created May 26, 2022 19:43
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save patmaddox/3ccea16b14e3690980f02dbb324003fb to your computer and use it in GitHub Desktop.
Save patmaddox/3ccea16b14e3690980f02dbb324003fb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
no_delete.sql
CREATE TABLE users (id serial PRIMARY KEY NOT NULL, username text NOT NULL);
INSERT INTO users (username) VALUES ('admin');
INSERT INTO users (username) VALUES ('pat');
CREATE RULE no_delete_admin AS ON DELETE TO users WHERE username='admin' DO INSTEAD NOTHING;
SELECT * FROM users;
DELETE FROM users;
SELECT * FROM users;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment