Fix migration for pgpro_version(): use pg_catalog schema.

Alexander Korotkov · Alexander Korotkov · commit 3a0ccc07da4c · 2016-05-04T12:58:57.000+03:00
diff --git a/src/pgpro-upgrade/pgpro_version.sql b/src/pgpro-upgrade/pgpro_version.sql
@@ -1 +1 @@
-CREATE FUNCTION pgpro_version() RETURNS TEXT AS 'pgpro_version' LANGUAGE internal STRICT IMMUTABLE;
+CREATE FUNCTION pg_catalog.pgpro_version() RETURNS TEXT AS 'pgpro_version' LANGUAGE internal STRICT IMMUTABLE;
diff --git a/src/pgpro-upgrade/pgpro_version.test b/src/pgpro-upgrade/pgpro_version.test
@@ -1 +1 @@
-select count(*) > 0 as pgpro_version from pg_proc where proname = 'pgpro_version';
+SELECT COUNT(*) > 0 AS pgpro_version FROM pg_proc WHERE proname = 'pgpro_version' AND pronamespace = 11;

Original file line number	Diff line number	Diff line change
`@@ -1 +1 @@`
`1`		`-CREATE FUNCTION pgpro_version() RETURNS TEXT AS 'pgpro_version' LANGUAGE internal STRICT IMMUTABLE;`
	`1`	`+CREATE FUNCTION pg_catalog.pgpro_version() RETURNS TEXT AS 'pgpro_version' LANGUAGE internal STRICT IMMUTABLE;`
Original file line number	Diff line number	Diff line change
`@@ -1 +1 @@`
`1`		`-select count(*) > 0 as pgpro_version from pg_proc where proname = 'pgpro_version';`
	`1`	`+SELECT COUNT(*) > 0 AS pgpro_version FROM pg_proc WHERE proname = 'pgpro_version' AND pronamespace = 11;`