Re: Bug or feature?

Hi Tom,

Thanks for your quick reply. However, I knew (and did that). My post were
more ... philosophical:

Shoudn't postgres extend priviledges to the sequences generated by a
create table ???

Regards,

On Fri, 11 May 2001, Tom Lane wrote:

> 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
> 

-- 
Olivier PRENANT             Tel:    +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)