Re: problem with upgrade from 6.5 -> 7.2 (fwd)

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