Custom Sequence | Community

Level 2

Solved

Custom Sequence

Forum|Forum|2 years ago
February 6, 2024
2 replies
1278 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by DavidKangni

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

Community Advisor

Accepted solution

Community Advisor

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

David Kangni

Level 2

hi @davidkangni ,

Thanks for your reply. Could you please explain a bit more?

1) How I am creating a new auto sequence in ACC?

2) where is this sequence stored in ACC? If possible to view the older Sequence?

Community Advisor

Community Advisor

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

Amine ABEDOUR