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
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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
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
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?
Views
Replies
Total Likes
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
Views
Likes
Replies
Views
Likes
Replies