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: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-patches

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                      
The PostgreSQL Company - Command Prompt, Inc.

Attachment: viewUpdate.c
Description: text/x-csrc (56.1 KB)
Attachment: viewUpdate.h
Description: text/x-chdr (656 bytes)


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-2017 The PostgreSQL Global Development Group