|
12 | 12 | *by PostgreSQL |
13 | 13 | * |
14 | 14 | * IDENTIFICATION |
15 | | - * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.365 2004/02/24 03:35:19 tgl Exp $ |
| 15 | + * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.366 2004/03/02 21:14:44 tgl Exp $ |
16 | 16 | * |
17 | 17 | *------------------------------------------------------------------------- |
18 | 18 | */ |
@@ -5080,8 +5080,16 @@ dumpCast(Archive *fout, CastInfo *cast) |
5080 | 5080 | if (!OidIsValid(cast->castfunc)) |
5081 | 5081 | appendPQExpBuffer(defqry,"WITHOUT FUNCTION"); |
5082 | 5082 | else |
5083 | | -appendPQExpBuffer(defqry,"WITH FUNCTION %s", |
| 5083 | +{ |
| 5084 | +/* |
| 5085 | + * Always qualify the function name, in case it is not in pg_catalog |
| 5086 | + * schema (format_function_signature won't qualify it). |
| 5087 | + */ |
| 5088 | +appendPQExpBuffer(defqry,"WITH FUNCTION %s.", |
| 5089 | +fmtId(funcInfo->pronamespace->nspname)); |
| 5090 | +appendPQExpBuffer(defqry,"%s", |
5084 | 5091 | format_function_signature(funcInfo,NULL, true)); |
| 5092 | +} |
5085 | 5093 |
|
5086 | 5094 | if (cast->castcontext=='a') |
5087 | 5095 | appendPQExpBuffer(defqry," AS ASSIGNMENT"); |
|