On 17 May 2014 13:25, Thomas Kellerer <[email protected]> wrote: > Hello, > > when playing with 9.4 beta I noticed that the result of pg_get_viewdef() > will not include the new WITH CHECK OPTION clause when the view was created > using it. > > Is that intended (if so: why?) or is this an oversight/bug? >
Yes, that's correct. pg_get_viewdef() only returns the underlying SELECT command for a view. This does not include any of the view's WITH parameters (check option and/or security barrier flag), because they aren't allowed in a SELECT statement. The additional parameters are held in pg_class.reloptions, and can be displayed from psql using \d+ Regards, Dean -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
