From 354547b0155ca9c2918d24b9dbf48eb04862ee38 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 24 Feb 2010 02:15:58 +0000 Subject: [PATCH] Un-break pg_dump for the case of zero-column tables. This was evidently broken by the CREATE TABLE OF TYPE patch. It would have been noticed if anyone had bothered to try dumping and restoring the regression database ... --- src/bin/pg_dump/pg_dump.c | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index cf38f167fb..95c08f11f9 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -12,7 +12,7 @@ * by PostgreSQL * * IDENTIFICATION - * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.573 2010/02/24 01:57:16 tgl Exp $ + * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.574 2010/02/24 02:15:58 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -10685,6 +10685,14 @@ dumpTableSchema(Archive *fout, TableInfo *tbinfo) if (actual_atts) appendPQExpBuffer(q, "\n)"); + else if (!tbinfo->reloftype) + { + /* + * We must have a parenthesized attribute list, even though empty, + * when not using the OF TYPE syntax. + */ + appendPQExpBuffer(q, " (\n)"); + } if (numParents > 0 && !binary_upgrade) { -- 2.40.0