Re: Switching Primary Keys to BigInt

Поиск
Список
Период
Сортировка
От Ireneusz Pluta/wp.pl
Тема Re: Switching Primary Keys to BigInt
Дата
Msg-id 168ca1b5-62bb-b210-bcd0-e1a9faacf728@wp.pl
обсуждение исходный текст
Ответ на Switching Primary Keys to BigInt  (Mohamed Wael Khobalatte <mkhobalatte@grubhub.com>)
Ответы Re: Switching Primary Keys to BigInt
Список 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 по дате отправления:

Предыдущее
От: MirrorX
Дата:
Сообщение: pglogical, replication_slots and going back in time
Следующее
От: Mohamed Wael Khobalatte
Дата:
Сообщение: Re: Switching Primary Keys to BigInt