pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
tables, permissions, sequences
2+ messages / 1 participants
[nested] [flat]

* tables, permissions, sequences
@ 2001-06-06 13:21  Martín Marqués <martin@bugs.unl.edu.ar>
  0 siblings, 1 reply; 2+ messages in thread

From: Martín Marqués @ 2001-06-06 13:21 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-sql

I have a database with a bunch of tables with owner martin. There are a bunch 
of views and rules also owned by martin (me! :-) ).
There is a group admin_users which has ALL privileges over the views. When 
ever I try to do an insert on the view (the rule executes a few inserts) I 
get this error:

ERROR: carrera_id_curso_seq.nextval: you don't have permissions to set 
sequence carrera_id_curso_seq

What's wrong?
I'm on Postgres 7.1.1.

Saludos... :-)

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: tables, permissions, sequences
@ 2001-06-12 15:17  Martín Marqués <martin@bugs.unl.edu.ar>
  parent: Martín Marqués <martin@bugs.unl.edu.ar>
  0 siblings, 0 replies; 2+ messages in thread

From: Martín Marqués @ 2001-06-12 15:17 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-sql

On Mié 06 Jun 2001 16:21, Martín Marqués wrote:
> I have a database with a bunch of tables with owner martin. There are a
> bunch of views and rules also owned by martin (me! :-) ).
> There is a group admin_users which has ALL privileges over the views. When
> ever I try to do an insert on the view (the rule executes a few inserts) I
> get this error:
>
> ERROR: carrera_id_curso_seq.nextval: you don't have permissions to set
> sequence carrera_id_curso_seq
>
> What's wrong?
> I'm on Postgres 7.1.1.
>
> Saludos... :-)

Hey, I end this mail a week ago, and just now i gets t the list? Is there 
something wrong with the mailling lists? Some of my mails get through fast 
(at most 4 hours it gets back here), and others, like this on, don't get 
through ever (or almost ever).

I'm not trying to hurt feelings. In Spanish we would say: "Es una critica 
constructiva" (it's a constructive criticism).

P.D.: Keep the good job.

Saludos.... :-)

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-06-12 15:17 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-06 13:21 tables, permissions, sequences Martín Marqués <martin@bugs.unl.edu.ar>
2001-06-12 15:17 ` Martín Marqués <martin@bugs.unl.edu.ar>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox