Re: Bug or feature?

Olivier PRENANT <ohp@pyrenet.fr> writes:
> I've just noticed that (after a upgrade from 7.0.3 to 7.1) the following
> did'nt work anymore:

> create tabla a (n1 serial, n2 int);
> grant all on a to nobody;

> <reconnect as user nobody>

> insert into a (n2) value (1);
> n1.nextval: you don't have permission to set sequence n1

> It worked on 7.0.3

You'll have to grant update rights on the sequence object to nobody ...
        regards, tom lane