Re: problem with upgrade from 6.5 -> 7.2 (fwd) - Mailing list pgsql-general

From Tom Lane
Subject Re: problem with upgrade from 6.5 -> 7.2 (fwd)
Date
Msg-id 6068.1015812619@sss.pgh.pa.us
Whole thread Raw
In response to problem with upgrade from 6.5 -> 7.2 (fwd)  (Michael Robinton <michael@insulin-pumpers.org>)
List pgsql-general
Michael Robinton <michael@insulin-pumpers.org> writes:
> note that "name_server_serial_seq" appear to be identical
> However, when I attempt to update the database in 7.2 I get this error:
> DBD::Pg::st execute failed: ERROR:  name_server_serial_seq.nextval: you
> don't have permissions to set sequence name_server_serial_seq

I forget what the default permissions were under 6.5, but under 7.0 and
later they're "no access except to owner".  You will need to explicitly
GRANT access to that sequence.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: RE:REFERENCES
Next
From: Darren Ferguson
Date:
Subject: Re: RE:REFERENCES