--On Montag, August 21, 2006 02:07:41 -0400 Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Hi, 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. Some functions are in need of some comments as well.
I'll try to complete the missing comments and to make some statements cleaner.
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?
--
Thanks
Bernd
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
match
