Re: Permission denied while insert - Mailing list pgsql-general

Jose Manuel Lorenzo Lopez wrote:

> Hi folks,
>
> I noticed a strange behavior of my DB. Let me explain:
>
> I created a table bdf_users as admin user 'postgres' and granted insert
> access for this table to public.
>
> Now I want to insert a line as user 'jose' (That's me!) and got the
> following message:
>
> ERROR:  bdf_users: Permission denied.
>
> Am I doing anything dumb? I am using postgresql 7.0.3 on SuSE Linux 7.1
> (although I compiled by myself postgresql)
>
> Best Regards
>
> José Manuel Lorenzo López
>


are you inserting directly over the table, or in a view of this table ?

I had problems inserting data in a View with no records ...




regards

Tulio