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

2010-06-01 Thread Richard Broersma
On Tue, Jun 1, 2010 at 6:07 AM, David Fetter wrote: > I'm not trying to be obtuse, but I am not understanding how you > connect this issue, which has to do with the way PostgreSQL's RULE > system works, with writeable CTEs, which have approximately nothing in > common with the issue except in tha

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

2010-06-01 Thread Marko Tiikkaja
On 2010-06-01 16:07 +0300, David Fetter wrote: > On Sat, May 29, 2010 at 08:21:46PM -0700, Richard Broersma wrote: >> On Sat, May 29, 2010 at 6:25 PM, David Fetter wrote: >> I wondering if write-able CTE's will be the silver bullet that will make rule based update-able views based multip

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

2010-06-01 Thread David Fetter
On Sat, May 29, 2010 at 08:21:46PM -0700, Richard Broersma wrote: > On Sat, May 29, 2010 at 6:25 PM, David Fetter wrote: > > >> 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 r

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

2010-05-29 Thread Richard Broersma
On Sat, May 29, 2010 at 8:21 PM, Richard Broersma wrote: > The following email was my first discovery that these kinds of > update-able view were not get-along well with client side optimistic > locking. > > http://archives.postgresql.org/pgsql-odbc/2006-12/msg00029.php Actually this link better

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

2010-05-29 Thread Richard Broersma
On Sat, May 29, 2010 at 6:25 PM, David Fetter wrote: >> 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

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

2010-05-29 Thread Bruce Momjian
David Fetter wrote: > On Sat, May 29, 2010 at 09:38:30PM -0400, Bruce Momjian wrote: > > David Fetter wrote: > > > 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... > > > > > > >

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

2010-05-29 Thread David Fetter
On Sat, May 29, 2010 at 09:38:30PM -0400, Bruce Momjian wrote: > David Fetter wrote: > > 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

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

2010-05-29 Thread Bruce Momjian
David Fetter wrote: > 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 b

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

2010-05-29 Thread David Fetter
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 > parti

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

2010-05-29 Thread Richard Broersma
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 th