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.