Project

General

Profile

Forums » Help »

Using Session.dropTables() on PostgreSQL with relations

Added by Anonymous about 12 years ago

Hello,

It seems it is not possible to use dbo::Session::dropTables() on a PostgreSQL backend if the databas has foreign keys to other tables. I get the error

ERROR: cannot drop table missions because other objects depend on it
DETAIL: constraint fk_table_fkname on table tablename depends on table tablename
HINT: Use DROP ... CASCADE to drop the dependent objects too.

Perhaps there should be an option for dropping with cascade? Or is there already somewhere?

Thanks


Replies (2)

RE: Using Session.dropTables() on PostgreSQL with relations - Added by Koen Deforche almost 12 years ago

Hey,

This shouldn't happen (i.e. the dropping happens taking into account dependencies). So it sounds like a bug.

Can you submit a bug ticket for this ?

Regards,

koen

RE: Using Session.dropTables() on PostgreSQL with relations - Added by Anonymous almost 12 years ago

I created a issue here: http://redmine.webtoolkit.eu/issues/1371. Let me know if you need more information.

Thanks!

    (1-2/2)