Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Lewis
Subject Re: Switching Primary Keys to BigInt
Date
Msg-id CAHOFxGqa9gEH5rsmMc=0=jzQn_nLuWTNkdRLnkF4Jj6zXqM7ig@mail.gmail.com
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
Tree view
Curious- what requires that the unique index be declared a primary key? What advantage does that give you? Just ensuring it isn't null?

Side note- EOL for 9.6 is coming next year so just a plug for upgrading when possible, perhaps utilizing pglogical to get to v11 or 12.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Switching Primary Keys to BigInt
Next
From: Mohamed Wael Khobalatte
Date:
Subject: Re: Switching Primary Keys to BigInt