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

On Sat, May 29, 2010 at 01:29:50PM -0700, Richard Broersma wrote:
> 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.

I'm not sure I understand.  When the concurrency issues in writeable
CTEs get fixed, they could become a mechanism for doing what you
describe, but I suspect there would be significant work involved in
harnessing them to that task.

They'll be pretty nice even without the automated view stuff, though :)

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate