Re: Updatable views

Bernd Helmle wrote:

> I'll try to complete the missing comments and to make some statements
> cleaner.

Thanks.

> --On Montag, August 21, 2006 02:07:41 -0400 Alvaro Herrera
> <alvherre@commandprompt.com> wrote:

> >The new files are src/backend/rewrite/viewUpdate.c and
> >src/include/rewrite/viewUpdate.h.  The third file, upd-views.sql, is
> >intended to be a new regression test.  Extra points if the table therein
> >is completed correctly.
> >
> >I haven't tested the array stuff at all.
> >
> >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?

Nope, no reason.  If you can find _where_ I broke it, that would be the
first clue to unbreaking it ;-)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support