Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

Data Model Questions /

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

PostgreSQL - all foreign keys are integer instead of bigints

Go to End



Community Member, 7 Posts

7 November 2013 at 7:45am

Edited: 07/11/2013 7:46am

Hi, when using PostgreSQL as the database, SilverStripe is generating integer foreign key data-types for all types of foreign keys, whereas the primary keys are bigints.

Is there a setting to fix this, or am I going to have to write SQL to change the data-types? Are there any other unforseen issues this could cause (once I've manually fixed the data-types) - e.g. will the SilverStripe data model still work ok - does it worry about the size of an integer ?