From a2e394838df09afa49cf3da3f75ca174b1e954c3 Mon Sep 17 00:00:00 2001 From: Nathan Wagner Date: Mon, 4 Oct 2021 09:20:01 -0500 Subject: [PATCH] add fk to queue --- tables/create.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/tables/create.sql b/tables/create.sql index 9e2c6c1..83a0fd3 100644 --- a/tables/create.sql +++ b/tables/create.sql @@ -43,7 +43,7 @@ from posting; -- need a separate table for deletes unless we post everything create table queue ( - table_oid regclass, + table_oid regclass references posting on delete cascade, pgroup integer default 0, -- see README.locking id text, -- id bigint, -- 2.50.1