Sqlite does offer triggers, tho. Is it possible to rewrite the ON DELETE...RESTRICT as a trigger and add it with pass-thru sql commands?
On Jun 9, 6:56 am, carlo <syseng...@gmail.com> wrote: > Foreign key constraints are not implemented in Sqlite (although it > parses the command). > > See:http://www.sqlite.org/omitted.html > > but you can use triggers. > > carlo > > On 9 Giu, 15:46, annet <annet.verm...@gmail.com> wrote: > > > Marco, > > > Did you test this in Sqlite: > > > db.define_table('table', > > db.Field('field',...,ondelete='RESTRICT'), > > migrate='table.table') > > > It does set the ON DELETE to RESTRICT in the foreign key constraint in > > Postres. > > > Annet. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
