--On Montag, August 21, 2006 02:07:41 -0400 Alvaro Herrera <[EMAIL PROTECTED]> wrote:


This is the patch for updatable views I've been able to come up with.  A
nasty bug was just discovered in the upcoming Mammoth Replicator release
so I'm not sure if I'm going to have time to work more on it soon.

So, I'll appreciate if somebody else takes the responsability to fix the
remaining issues.  I've put a lot of XXX's and some FIXME's.
functions are in need of some comments as well.

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

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?



Attachment: regress_view_update_check_option2.sql
Description: Binary data

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to