Skip site navigation (1) Skip section navigation (2)

Updatable views

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: viewUpdate.h
Description: text/x-chdr (656 bytes)
Attachment: viewUpdate.c
Description: text/x-csrc (56.1 KB)

Responses

pgsql-hackers by date

Next:From: Morus WalterDate: 2006-08-21 08:18:49
Subject: Re: pg_dump versus SERIAL, round N
Previous:From: Neil ConwayDate: 2006-08-21 05:56:12
Subject: Re: Costs estimates for (inline SQL) functions ...

pgsql-patches by date

Next:From: Albe LaurenzDate: 2006-08-21 13:57:43
Subject: Fix linking of OpenLDAP libraries
Previous:From: Tom LaneDate: 2006-08-21 01:01:39
Subject: Re: DROP OWNED BY doesn't work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group