problem with grant/revoke

Hi,

First I have to say that I wanted to search for this problem in the
mailing list archive, but each time I've tried it seemed the search engine
was halted or something because it timed out, so I've subscribed to this
list.

I use postgresql v6.5.2 and encounter a problem with permissions:

pcietest=> CREATE USER bob;
CREATE USER

pcietest=> GRANT ALL ON requete TO bob;
CHANGE

pcietest=> REVOKE DELETE ON requete FROM bob;
CHANGE

pcietest=> \connect pcietest bob
connecting to new database: pcietest as user: bob

pcietest=> UPDATE requete SET coderequete = 'hello' WHERE nomrequete =
'something';
ERROR: requete: Permission denied.

pcietest=> \connect pcietest jerome
connecting to new database: pcietest as user: jerome

pcietest=> GRANT DELETE ON requete TO bob;
CHANGE

pcietest=> \connect pcietest bob
connecting to new database: pcietest as user: bob

pcietest=> UPDATE requete SET coderequete = 'hello' WHERE nomrequete =
'something';
UPDATE 1

pcietest=>

it seems exactly like if the DELETE and UPDATE permissions were mapped to
the same thing, which is IMHO totally incorrect.

what do I do wrong ?
is it a bug or something ?

thanks for any help.

Jerome ALET - alet(at)unice(dot)fr - http://cortex.unice.fr/~jerome
Faculte de Medecine de Nice - http://noe.unice.fr - Tel: 04 93 37 76 30
28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE