Re: Updatable views

Bernd Helmle wrote:

> >Comments from Bernd and Jaime are especially welcome if I've broken
> >something that used to work on their patch :-)
>
> I see that the current patch doesn't support subqueries in the WHERE-clause
> anymore.
> You can find one example in the attached SQL-script. Is there a reason
> why you dropped this?

Hum, turns out that you had this code in the patch:

/*
if ( query->hasSubLinks == true )
{
elog( WARNING, "Subqueries violates SQL92 view update rules!" );
return false;
}
*/

I figured I'd remove the comments, and then forgot ... If you remove
the piece of code from the viewUpdate.c file, your sample script works.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.