summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/hs_primary_extremes.sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2022-01-15 15:54:10 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2022-01-15 15:54:10 -0500
commit4483b2cf29bfe8091b721756928ccbe31c5c8e14 (patch)
tree11852ad183bf4b5149e053f602ec8a7de521be4c /src/test/regress/sql/hs_primary_extremes.sql
parent46cf109089e8b0eeb3370c0f482b0aaf0becaae0 (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.sql73
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();