c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #29356
[Bug 789019] Re: unique keys missing
** Project changed: openobject-addons => openobject-server
** Also affects: openobject-addons
Importance: Undecided
Status: New
** Changed in: openobject-addons
Importance: Undecided => Low
** Changed in: openobject-addons
Status: New => Confirmed
** Changed in: openobject-addons
Assignee: (unassigned) => OpenERP R&D Addons Team 3 (openerp-dev-addons3)
--
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/789019
Title:
unique keys missing
Status in OpenERP Modules (addons):
Confirmed
Status in OpenERP Server:
Fix Committed
Bug description:
IMHO many tables should have uniquenes enforced using a column which
is "visible" for the user, because in production envirenment the user
has to identify and choose the correct resource "reading" the name or
similar.
Caveat: trailing blanks names with trailing "look" identical, but are not identical for check of uniqueness
IMHO it does not make sense to store trailing blanks. (in general)
(ASCII-Code 32, UnicodeU+0020.)
I recognize that there might be resources like partners having the
same "official" name and might be distinguish only by address or
similar. In this case name + reference/code must be used.
res.company - name
res.currency - symbol
res.partner - name (+ reference)
res.partner.bank - account or iban
account.period - name
account.tax - name
product_template - name (+code)
....
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/789019/+subscriptions
References