Did you grant the relevant permissions on just the table, or on both the
sequence and the table? You'll need to do both.
Heather Johnson
Senior Database Programmer
New York Post
Ron Ellingson wrote:
> I am having a problem adding a row to a postgresql table with a sequence
> as a primary key using pg_query. I receive an error, "permission denied
> for sequence mytable_tid_seq". I have set the permissions for the user
> from all which did not work to insert, update and select which did not
> work. Can you help. Thanks
>
> Ron Ellingson
> rellingson@satshot.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org