Re: Switching Primary Keys to BigInt - Mailing list pgsql-general

From Ireneusz Pluta/wp.pl
Subject Re: Switching Primary Keys to BigInt
Date
Msg-id 168ca1b5-62bb-b210-bcd0-e1a9faacf728@wp.pl
Whole thread Raw
In response to Switching Primary Keys to BigInt  (Mohamed Wael Khobalatte <mkhobalatte@grubhub.com>)
Responses Re: Switching Primary Keys to BigInt
List pgsql-general
W dniu 2020-07-21 o 17:30, Mohamed Wael Khobalatte pisze:
> we are planning to move some primary keys from int to bigint because we are approaching the type limit
If that does not break your business logic, you might arrange to use the negative half of the ::int 
value range. Ugly, but this might at least buy you some time before finding the definite and elegant 
way, if you are under some pressure. I do not recommend this, but this is what once saved my life 
(or at least one night), after I realized that my PK already reached the limit :-).



pgsql-general by date:

Previous
From: MirrorX
Date:
Subject: pglogical, replication_slots and going back in time
Next
From: Mohamed Wael Khobalatte
Date:
Subject: Re: Switching Primary Keys to BigInt