sorry, for now you have to do it manually

db.executesql('DROP TABLE tablename CASCADE;')

perhaps I can add an option to drop/truncate.

Massimo

On Feb 3, 9:01 pm, Baron <[email protected]> wrote:
> When I try to drop or truncate a table I get this error:
>
> ProgrammingError: cannot drop table dump because other objects depend
> on it
> HINT:  Use DROP ... CASCADE to drop the dependent objects too.
>
> Deleting from the table works fine because the deletions cascade. Is
> there a way to truncate or drop tables through the DAL that have
> foreign key dependencies?
>
> Baron
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to