From 55c3d86a2a374f9d8fd88fd947601c1f49a4da08 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sat, 16 Nov 2013 11:35:44 -0500 Subject: [PATCH] pg_upgrade: Fix some whitespace oddities --- contrib/pg_upgrade/check.c | 4 ++-- contrib/pg_upgrade/version_old_8_3.c | 8 ++++---- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/contrib/pg_upgrade/check.c b/contrib/pg_upgrade/check.c index 936306ce61..411689a85c 100644 --- a/contrib/pg_upgrade/check.c +++ b/contrib/pg_upgrade/check.c @@ -351,7 +351,7 @@ set_locale_and_encoding(ClusterInfo *cluster) res = executeQueryOrDie(conn, "SELECT datcollate, datctype " - "FROM pg_catalog.pg_database " + "FROM pg_catalog.pg_database " "WHERE datname = 'template0' "); assert(PQntuples(res) == 1); @@ -381,7 +381,7 @@ set_locale_and_encoding(ClusterInfo *cluster) res = executeQueryOrDie(conn, "SELECT pg_catalog.pg_encoding_to_char(encoding) " - "FROM pg_catalog.pg_database " + "FROM pg_catalog.pg_database " "WHERE datname = 'template0' "); assert(PQntuples(res) == 1); diff --git a/contrib/pg_upgrade/version_old_8_3.c b/contrib/pg_upgrade/version_old_8_3.c index 83334a09f6..84a47eec59 100644 --- a/contrib/pg_upgrade/version_old_8_3.c +++ b/contrib/pg_upgrade/version_old_8_3.c @@ -61,7 +61,7 @@ old_8_3_check_for_name_data_type_usage(ClusterInfo *cluster) " a.atttypid = 'pg_catalog.name'::pg_catalog.regtype AND " " c.relnamespace = n.oid AND " /* exclude possible orphaned temp tables */ - " n.nspname !~ '^pg_temp_' AND " + " n.nspname !~ '^pg_temp_' AND " " n.nspname !~ '^pg_toast_temp_' AND " " n.nspname NOT IN ('pg_catalog', 'information_schema')"); @@ -151,7 +151,7 @@ old_8_3_check_for_tsquery_usage(ClusterInfo *cluster) " a.atttypid = 'pg_catalog.tsquery'::pg_catalog.regtype AND " " c.relnamespace = n.oid AND " /* exclude possible orphaned temp tables */ - " n.nspname !~ '^pg_temp_' AND " + " n.nspname !~ '^pg_temp_' AND " " n.nspname !~ '^pg_toast_temp_' AND " " n.nspname NOT IN ('pg_catalog', 'information_schema')"); @@ -328,7 +328,7 @@ old_8_3_rebuild_tsvector_tables(ClusterInfo *cluster, bool check_mode) " a.atttypid = 'pg_catalog.tsvector'::pg_catalog.regtype AND " " c.relnamespace = n.oid AND " /* exclude possible orphaned temp tables */ - " n.nspname !~ '^pg_temp_' AND " + " n.nspname !~ '^pg_temp_' AND " " n.nspname !~ '^pg_toast_temp_' AND " " n.nspname NOT IN ('pg_catalog', 'information_schema')"); @@ -700,7 +700,7 @@ old_8_3_create_sequence_script(ClusterInfo *cluster) "WHERE c.relkind = 'S' AND " " c.relnamespace = n.oid AND " /* exclude possible orphaned temp tables */ - " n.nspname !~ '^pg_temp_' AND " + " n.nspname !~ '^pg_temp_' AND " " n.nspname !~ '^pg_toast_temp_' AND " " n.nspname NOT IN ('pg_catalog', 'information_schema')"); -- 2.40.0