Apologies, I committed the heinous crime of not creating a full working demo. It seems that Row Level Security is involved - I'll post an update with full code ASAP Phil Horder Database Mechanic
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных