If something is going to be included in DAL (and with that comes the "burden" of checking backward compatibility and so on) IMHO it should be at least supported by a lot of engines and have some meaningful "hole" covered.... This syntax is supported only in sqlite and if you're going to use DAL the functionality is "covered" by "update_or_insert()".... a lot of people seem to forget that you can create tables outside web2py and then define a model with migrate=False to achieve such particular functionalities...
On Tuesday, July 3, 2012 8:05:59 AM UTC+2, david karapetyan wrote: > > Is there a way to create a table with db.define_table that has a column > with an on conflict clause like 'create table t (col unique not null on > conflict ignore)'?
