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

Question

@isahore   @AndreaBriceno@ParthaSarathy@ParthaSarathy @ParthaS @AkshayAnand @Craig_Thonis @Manoj_Kumar_ @Amine_Abedour @Marcel_Szimonisz@DavidKangni @Amit_Kumar @ShashankNigam02@Ganesh5067@Jonathon_wodnicki @ParthaSarathy@ParthaSarathy @ParthaS @AkshayAnand @Craig_Thonis @Manoj_Kumar_ @Amine_Abedour @Marcel_Szimonisz@DavidKangni @Amit_Kumar @ShashankNigam02@Ganesh5067@Jonathon_wodnicki  hi all, one of our custom schema is using xtknewid sequence but we want to change it from  xtknewid sequence to custom dedicated sequence on custom schema how to change ?please help

AnirbanSi · Accepted Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO