Antonis Kanavouras (ankan(at)hungry(dot)gr) reports a bug with a severity of 3
The lower the number the more severe it is.
Granting insert on a table does not grant update to the ralated sequence
I recently upgrated to PostgreSQL 7.1.3 from 7.0.something (I don't remember exactly)
I dumped my databases, intstalled PostgreSQL v 7.1.3 and created my databases from the text-dump. The users privileges were allready set-up correctly on the tables. But everytime a user -other than the db owner- tried to insert a row in a table in witch he had append permission he got an error message. The reason: he had no update privilegde to the sometable_id_seq. ('id' in my case is an autoincrementing integer just to identify the row). I solved it so:
somedb# GRANT UPDATE ON sometable_id_seq TO someuser ;
but I think that this must be granted automaticaly when I grant insert to someuser on sometable.
No file was uploaded with this report
pgsql-bugs by date
|Next:||From: pgsql-bugs||Date: 2001-11-04 03:57:17|
|Subject: Bug #508: update not atomic|
|Previous:||From: Aaron Hillegass||Date: 2001-11-03 04:53:57|
|Subject: psql needs an option to set hostaddr instead of host|