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                      
The PostgreSQL Company - Command Prompt, Inc.

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


Reply via email to