Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5CGdBE43863 for ; Tue, 12 Jun 2001 12:39:11 -0400 (EDT) (envelope-from pgsql-general-owner@postgresql.org) 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 f56JKdE90531; Wed, 6 Jun 2001 15:20:40 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 41FA12AB3A; Wed, 6 Jun 2001 16:21:02 +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: tables, permissions, sequences Date: Wed, 6 Jun 2001 16:21:00 +0300 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <01060616210001.29859@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/427 X-Sequence-Number: 10826 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 -----------------------------------------------------------------