src/test/singlenode_isolation2/output/uao/update_while_vacuum.source

-- @Description Ensures that an update before a vacuum operation is ok
--
DROP TABLE IF EXISTS ao;
DROP
CREATE TABLE ao (a INT, b INT) USING @amname@;
CREATE
INSERT INTO ao SELECT i as a, i as b FROM generate_series(1, 100) AS i;
INSERT 100

DELETE FROM ao WHERE a < 12;
DELETE 11
1: BEGIN;
BEGIN
1: SELECT COUNT(*) FROM ao;
 count 
-------
 89    
(1 row)
1>: UPDATE ao SET b=1 WHERE a > 0;COMMIT;  <waiting ...>
2: VACUUM ao;
VACUUM
1<:  <... completed>
UPDATE
1: SELECT COUNT(*) FROM ao;
 count 
-------
 89    
(1 row)
3: INSERT INTO ao VALUES (0);
INSERT 1