pgsql: > Gavin Sherry <swm@linuxworld.com.au> writes: > > I ran across

Log Message:
-----------

Gavin Sherry <swm@linuxworld.com.au> writes:

I ran across this yesterday on HEAD:

template1=# grant select on foo, foo to swm;
ERROR: tuple already updated by self

Seems to fail similarly in every version back to 7.2; probably further,
but that's all I have running at the moment.

We could do away with the error by producing a unique list of object names
-- but that would impose an extra cost on the common case.

CommandCounterIncrement in the GRANT loop would be easier, likely.
I'm having a hard time getting excited about it though...

Yeah, its not that exciting but that error message would throw your
average user.

I've attached a patch which calls CommandCounterIncrement() in each of the
grant loops.

Gavin Sherry

Modified Files:
--------------
pgsql/src/backend/catalog:
aclchk.c (r1.116 -> r1.117)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/aclchk.c.diff?r1=1.116&amp;r2=1.117)