|
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 | +"(SELECTpg_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 | +"(SELECTpg_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 |
|
|