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.

Data Model Questions /

PostgreSQL - all foreign keys are integer instead of bigints


Reply


389 Views

Avatar
Antsb

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 ?