PostgreSQL 7.1 and Sequences

From: "Alastair D'Silva" <deece(at)newmillennium(dot)net(dot)au>
To: <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL 7.1 and Sequences
Date: 2001-04-22 09:28:21
Message-ID: 03ec01c0cb0e$935955e0$0a02a8c0@riker
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've recently upgraded to 7.1 and have the following situation which no
longer works:

As user "nmnadmin":

CREATE TABLE blah {
id NOT NULL SERIAL,
info text NOT NULL
};

GRANT SELECT, INSERT, UPDATE, DELETE ON blah TO nmnuser;

As user "nmnuser":

INSERT INTO blah (info) VALUES ('foo');

I get the following error:
blah_id_seq.nextval: you don't have permissions to set sequence blah_id_seq

Short of actually creating the sequence as "nmnuser", is there any way to
make this work?

Cheers,

--
Alastair D'Silva (mob: 0413 485 733)
Networking Consultant
New Millennium Networking (web: http://www.newmillennium.net.au)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2001-04-22 13:50:31 Re: PostgreSQL 7.1 and Sequences
Previous Message Louis-David Mitterrand 2001-04-22 08:20:04 Re: Trusted plperl