Re: unplanned sub-select error? - Mailing list pgsql-sql

Kyle Bateman <kyle@actarg.com> writes:
> Sorry, you're right.  I have now confirmed that this only happens when 
> updating via a view/rule (as you suspected).  Attached is a minimalist 
> sql file that demonstrates the same error message from a blank 
> database.  I'm using 8.1.0.  I'm pretty sure this problem did not exist 
> on 8.0.3.

Thanks for the test case.  I've confirmed it fails here in CVS tip but
not in 8.0 branch, so indeed it must be a new bug.  Will look into it.
        regards, tom lane