Received: from druid.net (druid.net [216.126.72.98]) by postgresql.org (Postfix) with ESMTP id 7EBC247593F for ; Tue, 12 Mar 2002 06:59:17 -0500 (EST) Received: by druid.net (Postfix, from userid 1000) id EB7E11C6C; Tue, 12 Mar 2002 06:59:21 -0500 (EST) Content-Type: text/plain; charset="iso-8859-1" From: "D'Arcy J.M. Cain" Reply-To: pgsql-sql@postgresql.org To: "GRIMOIS Eric" Subject: Re: GRANT problem ? Date: Tue, 12 Mar 2002 06:59:21 -0500 X-Mailer: KMail [version 1.3.2] References: <000b01c1c9ae$f3a42d40$3d04a837@PXXXX> In-Reply-To: <000b01c1c9ae$f3a42d40$3d04a837@PXXXX> Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20020312115921.EB7E11C6C@druid.net> X-Archive-Number: 200203/116 X-Sequence-Number: 6997 On March 12, 2002 05:16 am, GRIMOIS Eric wrote: > I get a error message when i do an INSERT in a table (Absence_jour) > containing a SERIAL field : > > ERROR: absence_jour_id_seq.nextval: you don't have permissions to set > sequence absence_jour_id_seq You have to grant permissions on the sequences separately from the table. It used to work as expected but at some point it changed for some reason. It certainly is inconvenient especially if you were used to the previous behaviour and wrote all you local tools based on it. You can get a list of all sequences with the "\ds" command in psql. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.