Re: Updatable views

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Bernd Helmle <mailings(at)oopsware(dot)de>
Cc: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Updatable views
Date: 2006-08-21 14:59:17
Message-ID: 20060821145917.GB24691@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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(at)commandprompt(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2006-08-21 15:11:40 Re: Updatable views
Previous Message Paul Silveira 2006-08-21 14:54:26 Re: snapshot replication with pg_dump

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2006-08-21 15:11:40 Re: Updatable views
Previous Message Bernd Helmle 2006-08-21 14:35:49 Re: Updatable views