From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking |
Date: | 2010-05-30 01:25:38 |
Message-ID: | 20100530012538.GD3615@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2010-05-30 01:38:30 | Re: Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking |
Previous Message | Justin Graf | 2010-05-30 01:20:01 | Re: Installing version 8.4 |