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

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Avatar

Re: Fwd: Database cleanup cannot drop table

by
Opener B.V., Stefan Rijnhart
- 19/12/2016 08:12:51
Hi Odoo dev,

can you file these respective bug reports on the openupgrade / server tools project and work with us there?

thank you.

Regards,
Stefan.


On 12/18/2016 06:53 PM, odoo dev wrote:
<blockquote cite="mid:CAJUJQdtynLOzkwyRcHn4d9EL1Ebs_YdE2xYTDP3171-zdraKAA@mail.gmail.com" type="cite">

---------- Forwarded message ----------
From: odoo dev <odoodev0@gmail.com>
Date: 2016-12-18 18:35 GMT+01:00
Subject: Database cleanup cannot drop table
To: "Odoo S.A. Community" <community@mail.odoo.com>


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: http://odoo-community.org/groups/contributors-15 Post to: mailto:contributors@odoo-community.org Unsubscribe: http://odoo-community.org/groups?unsubscribe

Reference