Hi Some databases support a INSERT INTO ... ON DUPLICATE KEY UPDATE handler. One of them is MySQL. Since it is not possible to write triggers for linked tables it is tricky to handle duplicate keys in a generic way. Therefore it would be cool to support this feature.
For my own needs I have simply overwritten the add() method in the org.h2.index.LinkedIndex class like this: http://pastebin.com/28ZPRFdi It would be very cool if you could implement this in a nice way, i.e. adding a property on linked table Thanks! Christian -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
