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

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Data Model Questions /

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

PostgreSQL - all foreign keys are integer instead of bigints

1193 Views

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 ?

Return to top