From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Updatable views |
Date: | 2006-08-21 06:07:41 |
Message-ID: | 20060821060741.GF1130@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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.
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 :-)
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Attachment | Content-Type | Size |
---|---|---|
viewUpdate.c | text/x-csrc | 56.1 KB |
viewUpdate.h | text/x-chdr | 656 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Morus Walter | 2006-08-21 08:18:49 | Re: pg_dump versus SERIAL, round N |
Previous Message | Neil Conway | 2006-08-21 05:56:12 | Re: Costs estimates for (inline SQL) functions ... |
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2006-08-21 13:57:43 | Fix linking of OpenLDAP libraries |
Previous Message | Tom Lane | 2006-08-21 01:01:39 | Re: DROP OWNED BY doesn't work |