openerp-india team mailing list archive

[jordg <gbj@xxxxxxxxxxxxxxx>]

Public bug reported:

In the table account_period the foreign key for company_id is not
defined as a foreign key in the database however it acts like one via
the API.

psql db_name
\d account_period

NOTE: no FOREIGN KEY (company_id) 
Foreign-key constraints:
    "account_period_create_uid_fkey" FOREIGN KEY (create_uid) REFERENCES res_users(id) ON DELETE SET NULL
    "account_period_fiscalyear_id_fkey" FOREIGN KEY (fiscalyear_id) REFERENCES account_fiscalyear(id) ON DELETE SET NULL
    "account_period_write_uid_fkey" FOREIGN KEY (write_uid) REFERENCES res_users(id) ON DELETE SET NULL

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/920267

Title:
  No Foreign key for company_id in account_period

Status in OpenERP Addons (modules):
  New

Bug description:
  In the table account_period the foreign key for company_id is not
  defined as a foreign key in the database however it acts like one via
  the API.

  psql db_name
  \d account_period

  NOTE: no FOREIGN KEY (company_id) 
  Foreign-key constraints:
      "account_period_create_uid_fkey" FOREIGN KEY (create_uid) REFERENCES res_users(id) ON DELETE SET NULL
      "account_period_fiscalyear_id_fkey" FOREIGN KEY (fiscalyear_id) REFERENCES account_fiscalyear(id) ON DELETE SET NULL
      "account_period_write_uid_fkey" FOREIGN KEY (write_uid) REFERENCES res_users(id) ON DELETE SET NULL

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/920267/+subscriptions