Re: Bug in pg_dump in 7.4.6?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bug in pg_dump in 7.4.6?
Date: 2005-01-12 15:14:51
Message-ID: 10736.1105542891@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark <gsstark(at)mit(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2005-01-12 15:44:11 Re: OID of current function
Previous Message Thomas Hallgren 2005-01-12 15:08:28 Re: OID of current function