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  ("Oliver Elphick" <olly@lfix.co.uk>)
Re: PostgreSQL 7.1 and Sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Louis-David Mitterrand
Дата:
Сообщение: Re: Trusted plperl
Следующее
От: "Oliver Elphick"
Дата:
Сообщение: Re: PostgreSQL 7.1 and Sequences