I've noticed that views for which I had never specified check_option or security_barrier (in pgsql 9.3) have got incorrect DDL generated - the "WITH (options)" clause is empty:
CREATE OR REPLACE VIEW account_v WITH () AS SELECT acc.id, ...
Once I set security_barrier on and back off for a view, it starts showing "WITH (security_barrier=FALSE)", not an empty "WITH ()" until I recreate a view. Probably that is the reason why the issue went unnoticed during development.
Attached patch should fix it.
You're right. Thanks for the patch, I commited and pushed it.
Wednesday, July 2, 2014, 7:47:42 PM, you wrote:
GL> Support the new check_option parameter of views