From 69ac90518f003895b8ffb6618b84b91ff4256308 Mon Sep 17 00:00:00 2001
From: Masaya Tojo <masaya@tojo.tokyo>
Date: Sat, 4 Mar 2023 20:21:24 +0900
Subject: Drop transaction_type.

---
 verify/transaction_type.sql | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'verify/transaction_type.sql')

diff --git a/verify/transaction_type.sql b/verify/transaction_type.sql
index 64de361..bce032f 100644
--- a/verify/transaction_type.sql
+++ b/verify/transaction_type.sql
@@ -3,8 +3,11 @@
 BEGIN;
 
 DO $$
+  DECLARE
+    type_count INTEGER;
   BEGIN
-    ASSERT (select 1 from pg_type where typname = 'transaction_type');
+    SELECT COUNT(*) INTO type_count FROM pg_type where typname = 'transaction_type';
+    ASSERT type_count = 0;
   END
 $$;
 
-- 
cgit v1.2.3

