Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Aug 21, 2012 at 10:47 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> * View options are problematic for pg_dump
>>
>> I had hoped those who created this problem were going to fix it, but
>> given the lack of response I guess I'll have to.
> This is my fault, but my hackers inbox got flooded and this got lost
> in the shuffle. Sorry. I can probably devote some time to it today
> if you don't want to be bothered with it. Do you have a sense of what
> the right fix is?
I can work on it if you're still swamped. I think it is probably
fixable by treating the view options as attached to the _RETURN rule
instead of the base table in pg_dump's objects. (There is an ALTER VIEW
command to set the security option, no?)
regards, tom lane