From 8d464d05d72c88a516994e2fa6d35d751163fe97 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 29 Jul 2001 22:12:23 +0000 Subject: [PATCH] Arrange for GRANT/REVOKE on a view to be dumped at the right time, namely after the view definition rather than before it. Bug introduced in 7.1 by changes to dump stuff in OID ordering. --- src/bin/pg_dump/pg_dump.c | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index 783193751b..1a18bb223c 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -22,7 +22,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.215 2001/07/17 00:30:35 tgl Exp $ + * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.216 2001/07/29 22:12:23 tgl Exp $ * * Modifications - 6/10/96 - dave@bensoft.com - version 1.13.dhb * @@ -3808,6 +3808,7 @@ dumpACL(Archive *fout, TableInfo tbinfo) *tok, *eqpos, *priv; + char *objoid; char *sql; char tmp[1024]; int sSize = 4096; @@ -3888,7 +3889,12 @@ dumpACL(Archive *fout, TableInfo tbinfo) free(aclbuf); - ArchiveEntry(fout, tbinfo.oid, tbinfo.relname, "ACL", NULL, sql, "", "", "", NULL, NULL); + if (tbinfo.viewdef != NULL) + objoid = tbinfo.viewoid; + else + objoid = tbinfo.oid; + + ArchiveEntry(fout, objoid, tbinfo.relname, "ACL", NULL, sql, "", "", "", NULL, NULL); } -- 2.40.0