* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> fujimoto@ceptord.net writes:
> > [ dump to archive, then pg_restore with -c option ]
>
> > Now all the access privileges on the public schema are gone:
>
> I can confirm this is broken in HEAD: "pg_dump -c test >test.out"
> produces a script including "GRANT ALL ON SCHEMA public TO PUBLIC",
> but "pg_dump -Fc test >test.dump; pg_restore -c test.dump" produces
> a script lacking that.
Ugh.
> Stephen attempted to fix this in 330b84d8c, but the fix was evidently done
> incorrectly. There should never be any difference between the results of
> these two procedures. I've not studied 330b84d8c, but my strong suspicion
> is that the logic was added to the wrong place in pg_dump.
I'm afraid it's not quite that simple, unfortunately.
I'll see what I can do though. I'm really curious how this was working
previously..
Thanks!
Stephen