Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking - Mailing list pgsql-general

From Richard Broersma
Subject Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking
Date
Msg-id AANLkTinYUDSkEQGRYNhcErdSo7KUHqSQOHxrhdETuJlT@mail.gmail.com
Whole thread Raw
Responses Re: Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking  (David Fetter <david@fetter.org>)
List 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

pgsql-general by date:

Previous
From: Richard Broersma
Date:
Subject: Re: child/parent creation
Next
From: Tom Wilcox
Date:
Subject: Re: Out of Memory and Configuration Problems (Big Computer)