diff options
| author | Tom Lane | 2005-01-04 22:27:46 +0000 |
|---|---|---|
| committer | Tom Lane | 2005-01-04 22:27:46 +0000 |
| commit | d877de9e6bd1fb6f9b1590ca0e6ce35b61077d6e (patch) | |
| tree | e9ff473d52e83188ef078e1f2b731aa0646b76dd | |
| parent | 10e5a759aab50786eb2e926105bb4b9a0a481d3b (diff) | |
Make pg_dump --oids work when default_with_oids = off. Per report from
Michael Fuhr.
| -rw-r--r-- | src/bin/pg_dump/pg_dump.c | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index 788aa129b33..73bc2134573 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.397 2004/12/31 22:03:08 pgsql Exp $ + * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.398 2005/01/04 22:27:46 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -7157,8 +7157,12 @@ setMaxOid(Archive *fout) Oid max_oid; char sql[1024]; - do_sql_command(g_conn, - "CREATE TEMPORARY TABLE pgdump_oid (dummy integer)"); + if (fout->remoteVersion >= 70200) + do_sql_command(g_conn, + "CREATE TEMPORARY TABLE pgdump_oid (dummy integer) WITH OIDS"); + else + do_sql_command(g_conn, + "CREATE TEMPORARY TABLE pgdump_oid (dummy integer)"); res = PQexec(g_conn, "INSERT INTO pgdump_oid VALUES (0)"); check_sql_result(res, g_conn, "INSERT INTO pgdump_oid VALUES (0)", PGRES_COMMAND_OK); @@ -7173,7 +7177,7 @@ setMaxOid(Archive *fout) if (g_verbose) write_msg(NULL, "maximum system OID is %u\n", max_oid); snprintf(sql, sizeof(sql), - "CREATE TEMPORARY TABLE pgdump_oid (dummy integer);\n" + "CREATE TEMPORARY TABLE pgdump_oid (dummy integer) WITH OIDS;\n" "COPY pgdump_oid WITH OIDS FROM stdin;\n" "%u\t0\n" "\\.\n" |