Re: [PORTS] Port Bug Report: pg_dump does incorrect save of permissions in 6.4

> Problem Description:
> --------------------
> pg_dump -z creates grant commands of the form
> grant "all" on "hotz" to "hotz";
> instead of
> grant "all" on "table" to "hotz";
>
> Don't know if this is fixed in newer dot revisions or 6.5.
>
> --------------------------------------------------------------------------
>
> Test Case:
> ----------
> pg_dump -z <database> >db.backup

I just did this:

    test=> create table test (x int);
    CREATE
    test=> grant all on test to postgres;
    CHANGE
    test=> \q
    #$ pg_dump -z -d test >/bjm/l
    pg_dump: The -z option(dump ACLs) is now the default, continuing.
    #$ less /bjm/l
    \connect - postgres
    CREATE TABLE "test" (
            "x" int4);
    REVOKE ALL on "test" from PUBLIC;
    GRANT ALL on "test" to "postgres";
    #$

Looks OK to me.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026