Re: psql :: support for \ev viewname and \sv viewname - Mailing list pgsql-hackers

From Tom Lane
Subject Re: psql :: support for \ev viewname and \sv viewname
Date
Msg-id 19570.1437597428@sss.pgh.pa.us
Whole thread Raw
In response to Re: psql :: support for \ev viewname and \sv viewname  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: psql :: support for \ev viewname and \sv viewname
List pgsql-hackers
Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> On 3 July 2015 at 20:50, Tom Lane <tgl@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



pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: psql :: support for \ev viewname and \sv viewname
Next
From: Robert Haas
Date:
Subject: Re: MultiXact member wraparound protections are now enabled