drop table cascade

[Baron]

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

[mdipierro]

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

[Baron]

thanks Massimo.

[mdipierro]

give this a try. In trunk

db.table.drop('cascade')

[Massimo Di Pierro]

What do you get? An error? What error?

On Friday, January 4, 2013 3:18:32 AM UTC-6, Liang wrote:

drop('cascade') seems not working.

[Liang Yi Aris]

No error shown in the interactive shell after executing the command. But the tables in the database are still there. I use Postgresql 9.2.

--
 
 
 

[Massimo Di Pierro]

Did you do db.commit() after the db.table.drop()?