Re: Bug in pg_dump in 7.4.6? - Mailing list pgsql-general

From Tom Lane
Subject Re: Bug in pg_dump in 7.4.6?
Date
Msg-id 10736.1105542891@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in pg_dump in 7.4.6?  (Greg Stark <gsstark@mit.edu>)
Responses Re: Bug in pg_dump in 7.4.6?  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> It seems the spurious SET SESSION AUTHORIZATION commands appear after any
> REVOKE/GRANT pair.

Oh, right.  In order to handle grants with GRANT OPTION, the dump data
may need to include SET SESSION AUTHORIZATION commands; so the code
assumes that it doesn't know the authorization any more after emitting
an ACL entry.  Not a bug.  It could possibly be smarter (eg grep the
text for "SET SESSION AUTHORIZATION" before deciding this) but since
that's not the default mode anymore anyway, I'm not very concerned.

            regards, tom lane

pgsql-general by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: OID of current function
Next
From: "Jim C. Nasby"
Date:
Subject: Re: OID of current function