pgsql-bugs@postgresql.org writes:
> Permissions on sequences are not restored when upgrading to 7.1
> Got a write error stating that I don't have permission to update xxxx.nextval
Actually, the permissions *are* restored; the problem is that 7.1 is
making more permission checks than prior versions did. You'll need to
GRANT the appropriate permissions on the sequence.
regards, tom lane