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@xxxxxxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
