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
-~----------~----~----~----~------~----~------~--~---

Reply via email to