When ID Generation: is selected for the Primary Key Attribute, the Semarchy application is responsible for creating numeric sequencing for an entity's primary key value. In the example below, entity SeedTest has a starting sequence of 7777. This value (by default) will increment by a single digit for each additional member added to the entity.
After an initial seed value is set in the Semarchy platform, an administrator may wish to review or modify this value.
To review the current value: using a SQL client like pgadmin, navigate to Schemas and expand the properties of the schema which contains the target objects. Next, expand the Sequences section, right-click the sequence matching your entity and click on Properties. Finally, click the Definitions label in the new dialog box, as pictured below.
To modify the current seed value:
In Definition, edit the Current Value then click Save at the bottom of the dialog box to save changes.
Execute changes programmatically by running the ALTER SEQUENCE script below, replacing schema and sequence values.
ALTER SEQUENCE semarchy_customer_b2c_mdm.seq_seed_test RESTART WITH 777;