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