Dean Rasheed <dean.a.rash...@gmail.com> writes: > On 3 July 2015 at 20:50, Tom Lane <t...@sss.pgh.pa.us> wrote: >> Oh? If that were true, pg_dump wouldn't work on such views. It is kind >> of a PITA for this purpose that it doesn't include the CREATE text for >> you, but we're surely not changing that behavior now.
> This appears to be missing support for view options (WITH CHECK OPTION > and security_barrier), so editing a view with either of those options > will cause them to be stripped off. Hm. Why exactly were those not implemented as part of pg_get_viewdef? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers