Andrew Dunstan wrote: > > On 01/23/2013 10:12 AM, Alvaro Herrera wrote: > >Improve concurrency of foreign key locking > > 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?
Basically this message says "a SELECT with a locking clause attached cannot be blah blah". There are many messages that had the original code saying "SELECT FOR UPDATE cannot be blah blah", which was later (8.1) updated to say "SELECT FOR UPDATE/SHARE cannot be blah blah". I expanded them using the same logic, but maybe there's a better suggestion? Note that the SELECT reference page now has a subsection called "The locking clause", so maybe it's okay to use that term now. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers