Custom Sequence

Question

Hi Team, Anyone help to clarify what is use of 'auto_XXXXX_XXXX_seq' is where I am finding this sequence in ACC? if provide a hands-on example it's very helpful to understand. @parthasarathy

DavidKangni · Accepted Answer

@kumar_27

auto sequence were added to ACC to avoid OOTB sequence exhaustion when using autopk in schema.

It's allowing tables to have their own sequence and not use xtkID used by delivery logs tracking logs etc.

It was introduced because customers with big data volume were having issue with data retention in ACC.

Thanks,

David

Amine_Abedour · Answer

Hello @kumar_27,The a custom sequence is created automaticaly for custom schema if you make the id of the schema an autopk : you can find the sequence name in the preview tab of schema form : In the database (if it's PostgreSQL), it will create a sequence object stored here and used for each insertion in your schema to retrieve new IDs :I hope it's clearer for you.Br,Amine

Sign up

Login with SSO

Login to the community

Login with SSO