Fix LATERAL references to target table of UPDATE/DELETE.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 0c051c90082da0b7e5bcaf9aabcbd4f361137cdc
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2014-01-07T20:25:27Z
Releases: 9.4.0
Fix LATERAL references to target table of UPDATE/DELETE.

I failed to think much about UPDATE/DELETE when implementing LATERAL :-(.
The implemented behavior ended up being that subqueries in the FROM or
USING clause (respectively) could access the update/delete target table as
though it were a lateral reference; which seems fine if they said LATERAL,
but certainly ought to draw an error if they didn't.  Fix it so you get a
suitable error when you omit LATERAL.  Per report from Emre Hasegeli.

Files