pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedtables, 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>
2001-06-12 15:17 ` Re: tables, permissions, sequences 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-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>
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