Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!

how to change xtknewid sequence to custom dedicated sequence on custom schema

Avatar

Level 4
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 1

you can create a new sequence by adding the pkSequence="sequenceName" in the element tag of the schema & autopk=true

 

Also you need to create sequence in database level 

 

CREATE SEQUENCE sequenceName START 101;

https://www.postgresql.org/docs/current/sql-createsequence.html