Bug #544: Upgrade to 7.1 - sequence permissions not restored
John Bradshaw (jbradsha@nortelnetworks.com) reports a bug with a severity of 4
The lower the number the more severe it is.
Short Description
Upgrade to 7.1 - sequence permissions not restored
Long Description
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
Sample Code
No file was uploaded with this report
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