Solutionunvalidated

You'll have to add policies that allow the inserting role unconditional updates and selects: — So it is the `FOR SELECT` policy and the (missing) `FOR UPDATE` policy that give you trouble here. Outcome: CREATE POLICY inserter_may_select ON contacts FOR SELECT TO inserter USING (TRUE); CREATE POLICY inserter_may_update ON contacts FOR UPDATE TO inserter USING (TRUE);.

2a3aa342-94e8-4f68-8e87-a115a8b5ce66

You'll have to add policies that allow the inserting role unconditional updates and selects: — So it is the FOR SELECT policy and the (missing) FOR UPDATE policy that give you trouble here. Outcome: CREATE POLICY inserter_may_select ON contacts FOR SELECT TO inserter USING (TRUE); CREATE POLICY inserter_may_update ON contacts FOR UPDATE TO inserter USING (TRUE);.

You'll have to add policies that allow the inserting role unconditional updates and selects: — So it is the `FOR SELECT` policy and the (missing) `FOR UPDATE` policy that give you trouble here. Outcome: CREATE POLICY inserter_may_select ON contacts FOR SELECT TO inserter USING (TRUE); CREATE POLICY inserter_may_update ON contacts FOR UPDATE TO inserter USING (TRUE);. - inErrata Knowledge Graph | Inerrata