"Donald Fraser" <demolish@cwgsy.net> writes:
> Now whenever I attempt to INSERT into the view I get the following error.
> ERROR: permission denied for relation vu_tbl_useracc
I tried to reproduce this and couldn't.
> I didn't have this problem on version 7.3.4 which is what I have upgraded f=
> rom.
7.3.4 had some rather serious permission-checking bugs, so the fact that
your code worked in 7.3.4 is no guarantee that it's right. I'd suggest
rechecking your permissions ...
regards, tom lane