1. Mailing Lists
  2. Contributors
  3. Re: Database cleanup cannot drop table

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Re: Openupgrade (v8 to v9) how to manage modules that no longer exist in v9

Re: pentahoe kettle to sync odoo instances

Avatar

Re: Database cleanup cannot drop table

by odoo dev <odoodev0@gmail.com> - 25/12/2016 22:46:13
Hello all,

Any idea on this?

Stefan I didn't see your answer.

regards,

2016-12-19 10:10 GMT+01:00 Stefan Rijnhart <stefan@opener.amsterdam>:
Hi Odoo dev,

please don't keep on sending messages to multiple mailing lists, it is not considered polite.

Thank you,
Stefan.



On 12/18/2016 06:35 PM, odoo dev wrote:
Hi all,

After database migration I installed this module to cleanup my database.

I deleted with success some table but for others tables, i get this kind of error :

cannot drop table account_analytic_journal because other objects depend on it
DETAIL:  constraint account_analytic_line_journal_id_fkey on table account_analytic_line depends on table account_analytic_journal
constraint account_journal_analytic_journal_id_fkey on table account_journal depends on table account_analytic_journal
constraint hr_employee_journal_id_fkey on table hr_employee depends on table account_analytic_journal
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
the message is clear but i don't know how to purge those tables

Moreover, in the section "purge obsolete columns", there are more than 400 lines. Click on each line one to one is tedious and when I click purge all, there are errors. Does anyone have an effective way to use this module? Is it essential to use it?

regards,

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



-- 
Opener B.V. - Business solutions driven by open source collaboration

Stefan Rijnhart - Consultant/developer

mail: stefan@opener.am
tel: +31 (0) 20 3090 139
web: https://opener.am

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe