@@ -3169,7 +3169,7 @@ getCollations(Archive *fout, int *numCollations)
31693169PGresult * res ;
31703170int ntups ;
31713171int i ;
3172- PQExpBuffer query = createPQExpBuffer () ;
3172+ PQExpBuffer query ;
31733173CollInfo * collinfo ;
31743174int i_tableoid ;
31753175int i_oid ;
@@ -3184,6 +3184,8 @@ getCollations(Archive *fout, int *numCollations)
31843184return NULL ;
31853185}
31863186
3187+ query = createPQExpBuffer ();
3188+
31873189/*
31883190 * find all collations, including builtin collations; we filter out
31893191 * system-defined collations at dump-out time.
@@ -6167,7 +6169,7 @@ getTSParsers(Archive *fout, int *numTSParsers)
61676169PGresult * res ;
61686170int ntups ;
61696171int i ;
6170- PQExpBuffer query = createPQExpBuffer () ;
6172+ PQExpBuffer query ;
61716173TSParserInfo * prsinfo ;
61726174int i_tableoid ;
61736175int i_oid ;
@@ -6186,6 +6188,8 @@ getTSParsers(Archive *fout, int *numTSParsers)
61866188return NULL ;
61876189}
61886190
6191+ query = createPQExpBuffer ();
6192+
61896193/*
61906194 * find all text search objects, including builtin ones; we filter out
61916195 * system-defined objects at dump-out time.
@@ -6257,7 +6261,7 @@ getTSDictionaries(Archive *fout, int *numTSDicts)
62576261PGresult * res ;
62586262int ntups ;
62596263int i ;
6260- PQExpBuffer query = createPQExpBuffer () ;
6264+ PQExpBuffer query ;
62616265TSDictInfo * dictinfo ;
62626266int i_tableoid ;
62636267int i_oid ;
@@ -6274,6 +6278,8 @@ getTSDictionaries(Archive *fout, int *numTSDicts)
62746278return NULL ;
62756279}
62766280
6281+ query = createPQExpBuffer ();
6282+
62776283/* Make sure we are in proper schema */
62786284selectSourceSchema (fout ,"pg_catalog" );
62796285
@@ -6340,7 +6346,7 @@ getTSTemplates(Archive *fout, int *numTSTemplates)
63406346PGresult * res ;
63416347int ntups ;
63426348int i ;
6343- PQExpBuffer query = createPQExpBuffer () ;
6349+ PQExpBuffer query ;
63446350TSTemplateInfo * tmplinfo ;
63456351int i_tableoid ;
63466352int i_oid ;
@@ -6356,6 +6362,8 @@ getTSTemplates(Archive *fout, int *numTSTemplates)
63566362return NULL ;
63576363}
63586364
6365+ query = createPQExpBuffer ();
6366+
63596367/* Make sure we are in proper schema */
63606368selectSourceSchema (fout ,"pg_catalog" );
63616369
@@ -6415,7 +6423,7 @@ getTSConfigurations(Archive *fout, int *numTSConfigs)
64156423PGresult * res ;
64166424int ntups ;
64176425int i ;
6418- PQExpBuffer query = createPQExpBuffer () ;
6426+ PQExpBuffer query ;
64196427TSConfigInfo * cfginfo ;
64206428int i_tableoid ;
64216429int i_oid ;
@@ -6431,6 +6439,8 @@ getTSConfigurations(Archive *fout, int *numTSConfigs)
64316439return NULL ;
64326440}
64336441
6442+ query = createPQExpBuffer ();
6443+
64346444/* Make sure we are in proper schema */
64356445selectSourceSchema (fout ,"pg_catalog" );
64366446
@@ -9467,16 +9477,18 @@ dumpCast(Archive *fout, CastInfo *cast)
94679477appendPQExpBuffer (defqry ,"WITH INOUT" );
94689478break ;
94699479case COERCION_METHOD_FUNCTION :
9480+ {
9481+ char * fsig = format_function_signature (fout ,funcInfo , true);
94709482
94719483/*
94729484 * Always qualify the function name, in case it is not in
94739485 * pg_catalog schema (format_function_signature won't qualify it).
94749486 */
9475- appendPQExpBuffer (defqry ,"WITH FUNCTION %s." ,
9476- fmtId (funcInfo -> dobj .namespace -> dobj .name ));
9477- appendPQExpBuffer (defqry ,"%s" ,
9478- format_function_signature (fout ,funcInfo , true));
9487+ appendPQExpBuffer (defqry ,"WITH FUNCTION %s.%s" ,
9488+ fmtId (funcInfo -> dobj .namespace -> dobj .name ),fsig );
9489+ free (fsig );
94799490break ;
9491+ }
94809492default :
94819493write_msg (NULL ,"WARNING: bogus value in pg_cast.castmethod field\n" );
94829494}