diff options
Diffstat (limited to 'src/bin/pg_dump/pg_dump.c')
| -rw-r--r-- | src/bin/pg_dump/pg_dump.c | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index 8733426e8ac..b807df58a85 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -13160,7 +13160,7 @@ dumpCollation(Archive *fout, CollInfo *collinfo) collinfo->dobj.catId.oid); else appendPQExpBuffer(query, "SELECT " - "'c'::char AS collprovider, " + "'c' AS collprovider, " "collcollate, " "collctype, " "NULL AS collversion " @@ -16549,13 +16549,16 @@ dumpSequence(Archive *fout, TableInfo *tbinfo) /* * Before PostgreSQL 10, sequence metadata is in the sequence itself, * so switch to the sequence's schema instead of pg_catalog. + * + * Note: it might seem that 'bigint' potentially needs to be + * schema-qualified, but actually that's a keyword. */ /* Make sure we are in proper schema */ selectSourceSchema(fout, tbinfo->dobj.namespace->dobj.name); appendPQExpBuffer(query, - "SELECT 'bigint'::name AS sequence_type, " + "SELECT 'bigint' AS sequence_type, " "start_value, increment_by, max_value, min_value, " "cache_value, is_cycled FROM %s", fmtId(tbinfo->dobj.name)); @@ -16566,7 +16569,7 @@ dumpSequence(Archive *fout, TableInfo *tbinfo) selectSourceSchema(fout, tbinfo->dobj.namespace->dobj.name); appendPQExpBuffer(query, - "SELECT 'bigint'::name AS sequence_type, " + "SELECT 'bigint' AS sequence_type, " "0 AS start_value, increment_by, max_value, min_value, " "cache_value, is_cycled FROM %s", fmtId(tbinfo->dobj.name)); |