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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Updatable views


  • From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
  • To: Patches <pgsql-patches(at)postgresql(dot)org>
  • Subject: Updatable views
  • Date: Mon, 21 Aug 2006 02:07:41 -0400
  • Message-id: <20060821060741.GF1130@alvh.no-ip.org> <text/plain>

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: upd-views-2.patch
Description: Text document

Attachment: viewUpdate.c
Description: Text Data

Attachment: viewUpdate.h
Description: Text Data

Attachment: upd-views.sql
Description: Text document



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group