PostgreSQL 7.1 and Sequences
| От | Alastair D'Silva |
|---|---|
| Тема | PostgreSQL 7.1 and Sequences |
| Дата | |
| Msg-id | 03ec01c0cb0e$935955e0$0a02a8c0@riker обсуждение исходный текст |
| Ответы |
Re: PostgreSQL 7.1 and Sequences
Re: PostgreSQL 7.1 and Sequences |
| Список | 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)
В списке pgsql-general по дате отправления: