From c489402a9302d66b747c58f0f3d4c39c082d03ef Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Tue, 16 Mar 2010 22:49:33 +0200 Subject: [PATCH] Discard notices from sqlmed test. DROP IF NOT EXIST can randomly show notice. --- expected/plproxy_sqlmed.out | 3 +-- sql/plproxy_sqlmed.sql | 3 +++ 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/expected/plproxy_sqlmed.out b/expected/plproxy_sqlmed.out index 9d831e5..97f0082 100644 --- a/expected/plproxy_sqlmed.out +++ b/expected/plproxy_sqlmed.out @@ -1,3 +1,4 @@ +set client_min_messages = 'warning'; drop foreign data wrapper if exists plproxy cascade; create foreign data wrapper plproxy; create server sqlmedcluster foreign data wrapper plproxy @@ -62,7 +63,6 @@ select * from sqlmed_compat_test(); -- override the test cluster with a SQL/MED definition drop server if exists testcluster cascade; -NOTICE: server "testcluster" does not exist, skipping create server testcluster foreign data wrapper plproxy options (partition_0 'dbname=regression host=localhost'); create user mapping for public server testcluster; @@ -75,7 +75,6 @@ select * from sqlmed_compat_test(); -- now drop the SQL/MED testcluster, and test fallback drop server testcluster cascade; -NOTICE: drop cascades to user mapping for public -- back on testcluster again select * from sqlmed_compat_test(); sqlmed_compat_test diff --git a/sql/plproxy_sqlmed.sql b/sql/plproxy_sqlmed.sql index 9ed64ac..3898ace 100644 --- a/sql/plproxy_sqlmed.sql +++ b/sql/plproxy_sqlmed.sql @@ -1,3 +1,6 @@ + +set client_min_messages = 'warning'; + drop foreign data wrapper if exists plproxy cascade; create foreign data wrapper plproxy; -- 2.39.5