Re: [COMMITTERS] pgsql: Improve concurrency of foreign key locking

Andres Freund <andres(at)2ndquadrant(dot)com> writes:
> On 2013-01-23 11:58:28 -0500, Andrew Dunstan wrote:
>> This error message change looks rather odd, and has my head spinning a bit:
>>
>> - errmsg("SELECT FOR UPDATE/SHARE cannot be applied to
>> the nullable side of an outer join")));
>> + errmsg("SELECT FOR UPDATE/SHARE/KEY UPDATE/KEY SHARE
>> cannot be applied to the nullable side of an outer join")))
>>
>> Can't we do better than that?

> I don't really see how? I don't think listing only the current locklevel
> really is an improvement and something like "SELECT ... FOR $locktype
> cannot .." seem uncommon enough in pg error messages to be strange.
> Now I aggree that listing all those locklevels isn't that nice, but I
> don't really have a better idea.

I don't really see what's wrong with the original spelling of the
message. The fact that you can now insert KEY in there doesn't really
affect anything for the purposes of this error.

regards, tom lane