diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2022-01-15 15:54:10 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2022-01-15 15:54:10 -0500 |
| commit | 4483b2cf29bfe8091b721756928ccbe31c5c8e14 (patch) | |
| tree | 11852ad183bf4b5149e053f602ec8a7de521be4c /src/test/regress/sql/hs_primary_extremes.sql | |
| parent | 46cf109089e8b0eeb3370c0f482b0aaf0becaae0 (diff) | |
Remove standby_schedule and associated test files.
Since this test schedule is not run by default, it's next door to
unused. Moreover, its test coverage is very thin, and what there is
is just about entirely superseded by the src/test/recovery tests.
Let's drop it instead of carrying obsolete tests.
Discussion: https://postgr.es/m/3911012.1641246643@sss.pgh.pa.us
Diffstat (limited to 'src/test/regress/sql/hs_primary_extremes.sql')
| -rw-r--r-- | src/test/regress/sql/hs_primary_extremes.sql | 73 |
1 files changed, 0 insertions, 73 deletions
diff --git a/src/test/regress/sql/hs_primary_extremes.sql b/src/test/regress/sql/hs_primary_extremes.sql deleted file mode 100644 index 2051e2e5cf2..00000000000 --- a/src/test/regress/sql/hs_primary_extremes.sql +++ /dev/null @@ -1,73 +0,0 @@ --- --- Hot Standby tests --- --- hs_primary_extremes.sql --- - -drop table if exists hs_extreme; -create table hs_extreme (col1 integer); - -CREATE OR REPLACE FUNCTION hs_subxids (n integer) -RETURNS void -LANGUAGE plpgsql -AS $$ - BEGIN - IF n <= 0 THEN RETURN; END IF; - INSERT INTO hs_extreme VALUES (n); - PERFORM hs_subxids(n - 1); - RETURN; - EXCEPTION WHEN raise_exception THEN NULL; END; -$$; - -BEGIN; -SELECT hs_subxids(257); -ROLLBACK; -BEGIN; -SELECT hs_subxids(257); -COMMIT; - -set client_min_messages = 'warning'; - -CREATE OR REPLACE FUNCTION hs_locks_create (n integer) -RETURNS void -LANGUAGE plpgsql -AS $$ - BEGIN - IF n <= 0 THEN - CHECKPOINT; - RETURN; - END IF; - EXECUTE 'CREATE TABLE hs_locks_' || n::text || ' ()'; - PERFORM hs_locks_create(n - 1); - RETURN; - EXCEPTION WHEN raise_exception THEN NULL; END; -$$; - -CREATE OR REPLACE FUNCTION hs_locks_drop (n integer) -RETURNS void -LANGUAGE plpgsql -AS $$ - BEGIN - IF n <= 0 THEN - CHECKPOINT; - RETURN; - END IF; - EXECUTE 'DROP TABLE IF EXISTS hs_locks_' || n::text; - PERFORM hs_locks_drop(n - 1); - RETURN; - EXCEPTION WHEN raise_exception THEN NULL; END; -$$; - -BEGIN; -SELECT hs_locks_drop(257); -SELECT hs_locks_create(257); -SELECT count(*) > 257 FROM pg_locks; -ROLLBACK; -BEGIN; -SELECT hs_locks_drop(257); -SELECT hs_locks_create(257); -SELECT count(*) > 257 FROM pg_locks; -COMMIT; -SELECT hs_locks_drop(257); - -SELECT pg_switch_wal(); |
