Re: 9.2RC1 wraps this Thursday ...

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Tue, Aug 21, 2012 at 10:47 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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