drop('cascade') seems not working.
On Wednesday, 4 February 2009 14:17:14 UTC+8, mdipierro wrote:
>
> 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
--