Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] something smells bad

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Alex Pilosov <alex(at)pilosoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] something smells bad
Date: 2001-06-06 15:57:13
Message-ID: 01060618571306.29859@bugs (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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] Martín Marqués 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.

More info:

webunl=> \dp
                   Access permissions for database "webunl"
          Relation           |               Access permissions
-----------------------------+------------------------------------------------
 admin_view                  | {"=r","martin=arwR","group webunl_admin=arwR"}
 admin_view_categ            | {"=r","martin=arwR","group webunl_admin=arwR"}
 admin_view_docente          | {"=r","martin=arwR","group webunl_admin=arwR"}
 admin_view_facultades       | {"=r","martin=arwR","group webunl_admin=arwR"}
 admin_view_materias         | {"=r","martin=arwR","group webunl_admin=arwR"}
 admin_view_modal            | {"=r","martin=arwR","group webunl_admin=arwR"}
 area                        | {"=r","martin=arwR"}
 area_id_area_seq            |
 carrera                     | {"=r","martin=arwR"}
 carrera_id_curso_seq        |
 categ                       | {"=r","martin=arwR"}
 categ_id_categ_seq          |
 docentes                    | {"=r","martin=arwR"}
 docentes_id_docente_seq     |
 facultad                    | {"=r","martin=arwR"}
 facultad_id_fac_seq         |
 inscripcion                 | {"=r","martin=arwR"}
 log_carrera                 | {"=","martin=arwR"}
 log_carrera_id_log_seq      |
 materias                    | {"=r","martin=arwR"}
 materias_id_mat_seq         |
 modalidad                   | {"=r","martin=arwR"}
 nexo_categ                  | {"=r","martin=arwR"}
 nexo_facultad               | {"=r","martin=arwR"}
 niveles                     | {"=r","martin=arwR"}
 niveles_id_nivel_seq        |
 resol                       | {"=r","martin=arwR"}
 sub_area                    | {"=r","martin=arwR"}
 sub_area_id_subarea_seq     |
 tipo_cursado                | {"=r","martin=arwR"}
 tipo_cursado_id_cursado_seq |
 tipo_modal                  | {"=r","martin=arwR"}
 tipo_modal_id_mod_seq       |


As you can see, the permissions look OK.

Saludos... :-)

-- 
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques                  |        mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2001-06-06 15:58:49
Subject: Re: SQL( "if ...exists...),how to do it in the PostgreSQL?
Previous:From: Tom LaneDate: 2001-06-06 15:54:18
Subject: Re: Can the backend return more than one error message per PQexec?

pgsql-general by date

Next:From: John MooreDate: 2001-06-06 16:01:47
Subject: Does PostgreSQL have implicit Order-by
Previous:From: Stephan SzaboDate: 2001-06-06 15:54:17
Subject: Re: [SQL] Foreign Keys and Inheritance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group