Details
-
Type:
Improvement
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects versions: 1.7
-
Fix versions: 1.7.9
-
Components: Database/schema, UI
-
Labels:None
Description
The sequence_by_type option in multipart_id_numbering.conf forces the numbering system to maintain a separate SERIAL sequence for each type having it set. Currently, if you set this on multiple types within a table (typical), the maximum value for each sequence is tracked using a combination table and element name (NOT type), which means if element names are reused across types the sequence separation fails.
This is confusing and should be changed such that type is included in the criteria used to track sequences.
This is confusing and should be changed such that type is included in the criteria used to track sequences.