From: D'Arcy J.M. Cain <darcy@druid.net>
To: GRIMOIS Eric <eric.grimois@cpam-cergypontoise.cnamts.fr>
Cc: pgsql-sql@postgresql.org
Subject: Re: GRANT problem ?
Date: Tue, 12 Mar 2002 06:59:21 -0500
Message-ID: <20020312115921.EB7E11C6C@druid.net> (raw)
In-Reply-To: <000b01c1c9ae$f3a42d40$3d04a837@PXXXX>
References: <000b01c1c9ae$f3a42d40$3d04a837@PXXXX>
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 <darcy@{druid|vex}.net> | 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: darcy@druid.net, eric.grimois@cpam-cergypontoise.cnamts.fr
Subject: Re: GRANT problem ?
In-Reply-To: <20020312115921.EB7E11C6C@druid.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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