On 11/11/05, Josh Berkus <josh@agliodbs.com> wrote: > Jaime, > > > so i suppose we can reuse many of the code breaking the merge in 3 > > pieces... for now they are just thougths, i will think more in this > > and try to implement it... > > > > comments? ideas? suggestions? > > Funny, we were just discussing this at OpenDBCon. Seems that you can't do a > full implementation of MERGE without Predicate Locking (the ability to say > "lock this table against inserts or updates of any row with key=5").
it isn't what select for update does? > However, Peter suggested that we could do a proof-of-concept implementation, > working out syntax and trigger issues, based on a full table lock and do the > hard work once it was proved to be feasable. > > Peter? > > -- > Josh Berkus > Aglio Database Solutions > San Francisco > -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
