On May 31, 2007, at 14:53 , Hackenberg, Rick wrote:
I am currently having a problem with an application that has been
working fine for the past few months. Whenever I try to add a new
entry into a table I receive the following message:
ERROR: permission denied for sequnce contractid
Please make sure you're providing the exact error message (i.e., copy
& paste).
Assuming you have a DEFAULT nextvai(contractid) on some column in the
table, you need UPDATE permissions on the sequence to use nextval.
See the GRANT documention page:
http://www.postgresql.org/docs/8.2/interactive/sql-grant.html
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
