openerp-india team mailing list archive

["Ferdinand @ Camptocamp" <912358@xxxxxxxxxxxxxxxxxx>]

IMHO the current implementation creates a lot of unnecessary tables

I suggest to store this information in a table with the following column
* relation name
* col1_id
* col2_id

or
table1_name
col1_name
col1_id
table2_name
col2_name
col2_id

or 2 columns
table1_name + col1_name + col1_id
table2_name + col2_name + col2_id

the design depends a bit on how  the search is ececuted

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

Title:
  check length of names needed

Status in OpenERP Server:
  Confirmed

Bug description:
  sometimes the names for relations can't be stored 
  example

  raising an error with modules to be installed which is hard to
  recover.

  example
  account_financial_report_webkit

  this works
  account_journal_account_report_general_ledger_webkit_rel_account_report_general_ledger_webkit_id_index
  but creates an index (cut off)
  account_journal_account_report_general_ledger_webkit_rel_accoun

  this fails
  account_journal_account_report_general_ledger_webkit_rel_account_journal_id_index

  obviously name length exceeded

  see attachment

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