On 22 July 2015 at 21:37, Tom Lane <t...@sss.pgh.pa.us> wrote: > 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? >
pg_get_viewdef in its current form is needed for the information_schema "views" view, which has separate columns for the view's query and its CHECK OPTIONs. Arguably another function could be added. However, given the need for psql to support older server versions, a new function wouldn't actually help much, since psql would still need to be able to do it the hard way in the absence of that new function on the server. Regards, Dean -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
