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
> > 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...
In response to
pgsql-hackers by date
|Next:||From: Robert Forsman||Date: 2001-06-06 22:32:37|
|Subject: Re: SQL( "if ...exists...),how to do it in the PostgreSQL?|
|Previous:||From: Tom Lane||Date: 2001-06-06 22:10:00|
|Subject: Re: Re: [PATCHES] Fw: Isn't pg_statistic a security hole - Solution Proposal |
pgsql-general by date
|Next:||From: Bruno Wolff III||Date: 2001-06-06 22:19:07|
|Subject: using create constraint trigger|
|Previous:||From: Alex Pilosov||Date: 2001-06-06 21:58:52|
|Subject: Re: [HACKERS] something smells bad|