Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5CLGpE01792; Tue, 12 Jun 2001 17:16:52 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 6D7402AB3A; Tue, 12 Jun 2001 18:17:15 +0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: tables, permissions, sequences Date: Tue, 12 Jun 2001 18:17:13 +0300 X-Mailer: KMail [version 1.2] References: <01060616210001.29859@bugs> In-Reply-To: <01060616210001.29859@bugs> MIME-Version: 1.0 Message-Id: <01061218171301.05332@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/424 X-Sequence-Number: 10845 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 -----------------------------------------------------------------