Use setseed() in RUN ON ANY regtest.

Without it, the test can fail occasionally.

Reported by Peter Eisentraut.

2 files changed, 7 insertions, 0 deletions

diff --git a/test/expected/plproxy_many.out b/test/expected/plproxy_many.out
index c7b65a0..57bf1c2 100644
--- a/test/expected/plproxy_many.out
+++ b/test/expected/plproxy_many.out
@@ -81,6 +81,12 @@ select test_multi(0, 'foo');
 (1 row)
 
 -- test RUN ON RANDOM
+select setseed(0.5);
+ setseed 
+---------
+ 
+(1 row)
+
 drop function test_multi(integer, text);
 create function test_multi(part integer, username text)
 returns setof integer as $$ cluster 'testcluster'; run on any; $$ language plproxy;
diff --git a/test/sql/plproxy_many.sql b/test/sql/plproxy_many.sql
index c1d2305..2d0074c 100644
--- a/test/sql/plproxy_many.sql
+++ b/test/sql/plproxy_many.sql
@@ -54,6 +54,7 @@ returns setof integer as $$ cluster 'testcluster'; run on 2; $$ language plproxy
 select test_multi(0, 'foo');
 
 -- test RUN ON RANDOM
+select setseed(0.5);
 drop function test_multi(integer, text);
 create function test_multi(part integer, username text)
 returns setof integer as $$ cluster 'testcluster'; run on any; $$ language plproxy;