From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 9.4 beta - pg_get_viewdef() and WITH CHECK OPTION |
Date: | 2014-05-19 06:04:17 |
Message-ID: | llc6t2$mt0$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dean Rasheed wrote on 19.05.2014 01:10:
>> 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+
Thanks, although not the answer I hoped for :)
I do think it would be a good thing to then have something like pg_get_full_viewdef (and a pg_get_full_tabledef() as well)
Regards
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Dean Rasheed | 2014-05-19 08:02:54 | Re: 9.4 beta - pg_get_viewdef() and WITH CHECK OPTION |
Previous Message | Sandeep Gupta | 2014-05-19 01:43:49 | slow query question: more indexes considered harmful |