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.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to