From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | "Alastair D'Silva" <deece(at)newmillennium(dot)net(dot)au> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL 7.1 and Sequences |
Date: | 2001-04-22 13:50:31 |
Message-ID: | 200104221350.f3MDoWU18059@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Alastair D'Silva" wrote:
>I've recently upgraded to 7.1 and have the following situation which no
>longer works:
...
>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?
GRANT UPDATE ON blah_id_seq TO nmnuser;
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"If my people, which are called by my name, shall
humble themselves, and pray, and seek my face, and
turn from their wicked ways; then will I hear from
heaven, and will forgive their sin, and will heal
their land." II Chronicles 7:14
From | Date | Subject | |
---|---|---|---|
Next Message | Louis-David Mitterrand | 2001-04-22 15:25:08 | last comma inside "CREATE TABLE ()" statements |
Previous Message | Alastair D'Silva | 2001-04-22 09:28:21 | PostgreSQL 7.1 and Sequences |