Access denied on trigger UPDATE even with UPDATE perms

[Wells Oliver <wells.oliver@xxxxxxxxx>]

A role has UPDATE on table A.

There's a trigger on table B which updates A.

The user can insert into B, but the trigger to update A fails:

CONTEXT:  SQL statement "UPDATE A SET c = NEW.c WHERE id = NEW.id"
PL/pgSQL function schema.tg_function() line 3 at SQL statement

What additional perms are needed so the user inserting into B (which they have permission for) can successfully update A via that trigger?

--

Wells Oliver
wells.oliver@xxxxxxxxx