Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug #544: Upgrade to 7.1 - sequence permissions not restored - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #544: Upgrade to 7.1 - sequence permissions not restored
Date
Msg-id 29493.1008774386@sss.pgh.pa.us
Whole thread Raw
In response to Bug #544: Upgrade to 7.1 - sequence permissions not restored  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: "Henshall, Stuart - WCP"
Date:
Subject: After ~Crash Sequence not correct
Next
From: Tom Lane
Date:
Subject: Re: After ~Crash Sequence not correct