OHDSI Home | Forums | Wiki | Github

PK limitation with int4 in postgre

Dear Colleagues,

During the mapping of our data to OMOP we have detected that different data sources either have more than 2,147,483,647 values (limitation of int4 in postgre) or, if we try to keep the PKs of the source, it does not allow us to insert them due to size exceedance. Is there any solution for postgre to increase the size of the PKs without compromising the OMOP model? Using a sequence would still persist the problem for the first case.

Thank you very much in advance,

Jose Manuel