give this a try. In trunk
db.table.drop('cascade')
On Feb 3, 11:40 pm, Baron <[email protected]> wrote:
> thanks Massimo.
>
> On Feb 4, 3:28 pm, mdipierro <[email protected]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
