Обсуждение: 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