Re: 9.2RC1 wraps this Thursday ...

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2012-08-21T16:13:36Z
Lists: pgsql-hackers
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