Olivier PRENANT <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to