Another place that needs schema qualification.

tglsfdc · tglsfdc · commit 9ca89b4f8c55 · 2002-05-29T01:49:57.000Z
diff --git a/src/bin/pg_dump/pg_backup_archiver.c b/src/bin/pg_dump/pg_backup_archiver.c
@@ -15,7 +15,7 @@
  *
  *
  * IDENTIFICATION
- *		$Header: /cvsroot/pgsql/src/bin/pg_dump/pg_backup_archiver.c,v 1.48 2002/05/29 01:38:56 tgl Exp $
+ *		$Header: /cvsroot/pgsql/src/bin/pg_dump/pg_backup_archiver.c,v 1.49 2002/05/29 01:49:57 tgl Exp $
  *
  * Modifications - 28-Jun-2000 - pjw@rhyme.com.au
  *
@@ -597,12 +597,12 @@ _enableTriggersIfNecessary(ArchiveHandle *AH, TocEntry *te, RestoreOptions *ropt
 	 */
 	if (te && te->name && strlen(te->name) > 0)
 		ahprintf(AH, "UPDATE pg_catalog.pg_class SET reltriggers = "
-				 "(SELECT count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid) "
+				 "(SELECT pg_catalog.count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid) "
 				 "WHERE oid = '%s'::pg_catalog.regclass;\n\n",
 				 fmtId(te->name, false));
 	else
 		ahprintf(AH, "UPDATE pg_catalog.pg_class SET reltriggers = "
-				 "(SELECT count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid) "
+				 "(SELECT pg_catalog.count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid) "
 				 "FROM pg_catalog.pg_namespace "
 				 "WHERE relnamespace = pg_namespace.oid AND nspname !~ '^pg_';\n\n");
 

Original file line number	Diff line number	Diff line change
`@@ -15,7 +15,7 @@`
`15`	`15`	`*`
`16`	`16`	`*`
`17`	`17`	`* IDENTIFICATION`
`18`		`- * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_backup_archiver.c,v 1.48 2002/05/29 01:38:56 tgl Exp $`
	`18`	`+ * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_backup_archiver.c,v 1.49 2002/05/29 01:49:57 tgl Exp $`
`19`	`19`	`*`
`20`	`20`	`* Modifications - 28-Jun-2000 - pjw@rhyme.com.au`
`21`	`21`	`*`
`@@ -597,12 +597,12 @@ _enableTriggersIfNecessary(ArchiveHandle AH, TocEntry te, RestoreOptions *ropt`
`597`	`597`	`*/`
`598`	`598`	`if (te && te->name && strlen(te->name) > 0)`
`599`	`599`	`ahprintf(AH, "UPDATE pg_catalog.pg_class SET reltriggers = "`
`600`		`- "(SELECT count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid) "`
	`600`	`+ "(SELECT pg_catalog.count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid) "`
`601`	`601`	`"WHERE oid = '%s'::pg_catalog.regclass;\n\n",`
`602`	`602`	`fmtId(te->name, false));`
`603`	`603`	`else`
`604`	`604`	`ahprintf(AH, "UPDATE pg_catalog.pg_class SET reltriggers = "`
`605`		`- "(SELECT count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid) "`
	`605`	`+ "(SELECT pg_catalog.count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid) "`
`606`	`606`	`"FROM pg_catalog.pg_namespace "`
`607`	`607`	`"WHERE relnamespace = pg_namespace.oid AND nspname !~ '^pg_';\n\n");`
`608`	`608`