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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026