On 3 July 2015 at 20:50, Tom Lane <t...@sss.pgh.pa.us> wrote: > Petr Korobeinikov <pkorobeini...@gmail.com> writes: >> Fixed. Now both \ev and \sv numbering lines starting with "1". New version >> attached. > > Applied with a fair amount of mostly-cosmetic adjustment. > >> As I've already noticed that pg_get_viewdef() does not support full syntax >> of creating or replacing views. > > 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. 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
