Re: [HACKERS] something smells bad

On Wed, 6 Jun 2001, [iso-8859-1] Martn Marqus wrote:

> On Jue 07 Jun 2001 00:58, you wrote:
> > 1) Please don't crosspost to both hackers and general
> >
(plonk myself)

> > On Wed, 6 Jun 2001, [iso-8859-1] Martn Marqus wrote:
> > > ERROR: carrera_id_curso_seq.nextval: you don't have permissions to set
> > > sequence carrera_id_curso_seq
> >
> > Because of the way postgres works, you need to grant write permission on
> > the carrera_id_curso_seq for your inserts to succeed.
>
> This doesn't sound logical. The user from the group granted can insert data,
> but not in a SERIAL field?
> This is not what the "RULES and permissions" documentation says.
I guess the documentation has to be changed then.

Postgres sequences are really non-transparent, and you have to be aware of
that. Such as, when you drop the table, sequence won't get dropped,
permissions are separate on table and sequence, and various other things.

> area_id_area_seq |
> carrera_id_curso_seq |
> categ_id_categ_seq |
> docentes_id_docente_seq |
> facultad_id_fac_seq |
> log_carrera_id_log_seq |
> materias_id_mat_seq |
> niveles_id_nivel_seq |
>
> As you can see, the permissions look OK.
You must have permissions on _seq as well as on the underlying table...