Re: HELP! BUG? pg_dump mucks up grant/revoke - Mailing list pgsql-general

teg@redhat.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