Skip to main content
Level 4
Feb 29, 2024 1:45 PM UTC
Solved

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
AnirbanSiAccepted solution
Mar 1, 2024 7:01 AM UTC

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

1 reply

AnirbanSiAccepted solution
Mar 1, 2024 7:01 AM UTC

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

Translate