Jump to:

3430 Posts in 1057 Topics by 734 members

Data Model Questions

SilverStripe Forums » Data Model Questions » PostgreSQL - all foreign keys are integer instead of bigints

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

Page: 1
Go to End
Author Topic: 287 Views
  • Antsb
    Avatar
    Community Member
    7 Posts

    PostgreSQL - all foreign keys are integer instead of bigints Link to this post

    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 ?

    287 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.