Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking
Date: 2010-05-29 20:29:50
Message-ID: AANLkTinYUDSkEQGRYNhcErdSo7KUHqSQOHxrhdETuJlT@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This might be a premature question considering write-able CTEs are not
in core, but...

I wondering if write-able CTE's will be the silver bullet that will
make rule based update-able views based multiple vertically
partitioned table robust. By robust, I mean to elimination the update
anomalies that can occur from the view point client side optimistic
locking where the virtual row appears to be inconsistently updated.

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Graf 2010-05-29 20:34:16 Re: child/parent creation
Previous Message Richard Broersma 2010-05-29 19:52:23 Re: child/parent creation