On Fri, Jun 11, 2010 at 05:35, Philip Martin <philip.mar...@wandisco.com> wrote: >... > This SQL stuff is all a bit new to me. Why do you choose to have > distinct insert and update queries rather than an insert or replace > query? Should there be a transaction to combine the SELECT query with
There could be an ACTUAL_NODE row already. You don't want to *replace* it. You could lose (say) edited properties. Cheers, -g