Skip site navigation (1) Skip section navigation (2)

Duplicate object names in GRANT

From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Duplicate object names in GRANT
Date: 2005-07-27 03:47:25
Message-ID: Pine.LNX.4.58.0507271339530.22654@linuxworld.com.au (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Hi all,

I ran across this yesterday on HEAD:

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

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. It seems to me
that producing a useful error message would entail the same cost, however.

Thoughts?

Gavin

Responses

pgsql-hackers by date

Next:From: brookDate: 2005-07-27 03:58:26
Subject: psql as an execve(2) interpreter
Previous:From: Tom LaneDate: 2005-07-27 03:37:45
Subject: Re: ENUM type

pgsql-patches by date

Next:From: Tom LaneDate: 2005-07-27 04:41:26
Subject: Re: Duplicate object names in GRANT
Previous:From: Neil ConwayDate: 2005-07-27 01:41:30
Subject: pg_dump: fix crash on error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group