On Wed, Jan 28, 2026 at 12:19 PM Steve Chavez <[email protected]> wrote:
> > I’d be more inclined to change this incompatibility than try to affect > action at a distance with a database setting. > > Could we instead have a shortcut for view creation like `CREATE SECURE > VIEW` (would be the same as WITH (security_invoker = true)`) ? This at > least makes it harder to forget specifying the option and also denotes that > by default views are insecure (since they're most likely created by > security_definer=superuser) > > Please don't top-post. Inventing alternative syntax with the same fundamental issue, just an arguably different failure threshold, is unappealing. David J.
