[GENERAL] PostgreSQL 7.1 and Sequences

[Alastair D'Silva]

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)


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]