Re: Bug #544: Upgrade to 7.1 - sequence permissions not restored

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jbradsha(at)nortelnetworks(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #544: Upgrade to 7.1 - sequence permissions not restored
Date: 2001-12-19 15:06:26
Message-ID: 29493.1008774386@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-12-19 16:02:53 Re: After ~Crash Sequence not correct
Previous Message Henshall, Stuart - WCP 2001-12-19 13:00:17 After ~Crash Sequence not correct