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

In response to

• Re: [HACKERS] something smells bad at 2001-06-06 15:57:13 from Martín Marqués

Responses

• Re: [HACKERS] something smells bad at 2001-06-06 16:12:46 from Martín Marqués

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