The problem is that some dbs do not support the "IF IT EXISTS" part. This means we would need a lot of additional web2py structure to handle it. It is going to add a lot of complexity and it may not be as flexible as raw SQL. The question is, it is worth it?
Massimo On Dec 16, 3:27 am, billf <[email protected]> wrote: > I followed this thread with interest. Strictly speaking, does one > also need to add a unique index to the table, e.g. > > db.executesql('CREATE UNIQUE INDEX IF NOT EXISTS person_voterid ON > voter (lastname,firstname,voterid)) > > I understand that the syntax can vary between databases. > > How difficult would it be to support the creation of indices in the > DAL? I think I'll start another thread :-) > > On Dec 16, 2:02 am, DenesL <[email protected]> wrote: > > > Mistyped the requires... > > Thank you Massimo. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
