On Wed, Sep 23, 2015 at 11:05 AM, Stephen Frost <sfr...@snowman.net> wrote: >> Gosh, I think it would have been better to have a cleaner separation >> of USING and WITH CHECK. That sounds far too unnecessarily magical. > > That the USING policy is used if WITH CHECK isn't defined? That was > simply done to make policy management simple as in quite a few cases > only one policy is needed. If a WITH CHECK was always required then > you'd be constantly writing: > > CREATE POLICY p1 ON t1 > USING (entered_by = current_user) > WITH CHECK (entered_by = current_user); > > With potentially quite lengthy expressions. > > I'm not against changing that if people feel strongly about it, but I > certainly find it extremely handy. > > If that wasn't what you were referring to then please clarify as I > didn't follow.
No, that's what I was talking about. Maybe it is the most useful behavior, but it seems to have surprised Peter, and it surprised me, too. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
