Re: HELP! BUG? pg_dump mucks up grant/revoke

teg(at)redhat(dot)com (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes:
> Are those also in the 7.1-stable branch?

Yes. There are quite a few fixes in the stable branch since 7.1.2,
actually. I made a list last week of commits that either were already
in REL7_1_STABLE, or looked like they deserved to be back-patched if we
were about to make a patch release. Updated, it looks like:

2001-08-03 16:14 tgl

* src/bin/pg_dump/: pg_dump.c, pg_dump.h (REL7_1_STABLE):
Back-patch fixes for dumping user-defined types and dumping
comments on views.

2001-07-31 14:39 tgl

* src/: backend/optimizer/path/allpaths.c,
backend/optimizer/util/clauses.c, backend/utils/adt/ruleutils.c,
include/optimizer/clauses.h (REL7_1_STABLE): Fix optimizer to
not try to push WHERE
clauses down into a sub-SELECT that has a DISTINCT ON clause, per
bug report from Anthony Wood. While at it, improve the
DISTINCT-ON-clause recognizer routine to not be fooled by out-
of-order DISTINCT lists. Also, back-patch earlier fix to not push
down into sub-SELECT with LIMIT.

2001-07-29 18:12 tgl

* src/bin/pg_dump/: pg_dump.c (REL7_1_STABLE), pg_dump.c: 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.

2001-07-16 13:57 tgl

* src/backend/optimizer/path/allpaths.c: Do not push down quals
into subqueries that have LIMIT/OFFSET clauses, since the added
qual could change the set of rows that get past the LIMIT. Per
discussion on pgsql-sql 7/15/01.

2001-07-11 17:53 momjian

* src/backend/commands/copy.c: Disable COPY TO/FROM on views.

2001-07-05 22:13 ishii

* doc/src/sgml/backup.sgml (REL7_1_STABLE): Fix typo. createdb -t
--> createdb -T

2001-07-03 12:49 tgl

* src/backend/utils/init/miscinit.c: Don't go into infinite loop if
/home/postgres/testversion/data directory is not writable.

2001-07-02 15:31 tgl

* src/test/regress/expected/: abstime-solaris-1947.out,
abstime.out: Update abstime expected results to match
post-30-June-2001 reality. Probably the right fix is to remove
'current' special value entirely, but I don't want to see
regression test failures until that happens.

2001-06-29 12:34 tgl

* src/backend/commands/: vacuum.c (REL7_1_STABLE), vacuum.c: Fix
longstanding error in VACUUM: sometimes would examine a buffer page
after writing/unpinning it. An actual failure is unlikely, unless
the system is tremendously short of buffers ... but a bug is a bug.

2001-06-12 21:02 tgl

* src/pl/plpgsql/src/pl_exec.c (REL7_1_STABLE): Back-patch fix for
attempt to pfree a value that's not palloc'd (it's a field of a
tuple). I see Jan has already fixed this in current sources, but
7.1.* is pretty badly broken here.

2001-06-12 14:54 tgl

* src/backend/rewrite/: rewriteHandler.c (REL7_1_STABLE),
rewriteHandler.c: Repair problem with multi-action rules in
combination with any nontrivial manipulation of rtable/jointree by
planner. Rewriter was generating actions that shared
rtable/jointree substructure, which caused havoc when planner got
to the later actions that it'd already mucked up.

2001-06-06 14:54 wieck

* src/pl/plpgsql/src/gram.y: Patch from Ian Lance Taylor fixing
multiple cursor arguments and buffer zero termination.

Jan

2001-06-06 13:18 tgl

* src/backend/access/transam/xlog.c (REL7_1_STABLE): Back-patch
change to not keep WAL segments just for UNDO information.

2001-05-31 17:49 momjian

* doc/src/sgml/: release.sgml (REL7_1_STABLE), release.sgml: Forgot
SGML section section id tag for 7.1.

2001-05-31 13:32 tgl

* src/backend/utils/adt/: ri_triggers.c (REL7_1_STABLE),
ri_triggers.c: RI triggers would fail for datatypes using old-style
equal function, because cached fmgr info contained reference to a
shorter-lived data structure. Also guard against possibility that
fmgr_info could fail, leaving an incomplete entry present in the
hash table.

2001-05-27 21:00 ishii

* src/backend/utils/mb/: conv.c (REL7_1_STABLE), conv.c: Fix a
message error in utf_to_local

regards, tom lane