id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 29787,ForeignKey to User with BigIntegerField id/pk gets created as 'integer' instead of 'bigint' field in postgres,Andrew Badr,nobody,"I ran into this bug when upgrading from 1.10 to 1.11. All my models have BigInteger ids. My test case creates a User model instance, then creates another model instance pointing to it via ForeignKey. On 1.10, this works fine, and inspecting the database shows the fk field as having type 'bigint' in postgres. On 1.11, the test fails, and inspecting the db shows the field as a regular 'integer'. After some digging, I've found that this bug happens, oddly, at different commits for different models. For some models (??) it occurs starting in 45ded053b1f4320284aa5dac63052f6d1baefea9 (#27666). For others, b8a2f3c2d66aa15af4be745a576609b958a853c0 is the first bad commit (fix for #28305; comes between 1.11.7 and 1.11.8). The fact that the former has to do with migrations might be a clue. I tried to repro with a minimal test case on a fresh project, but sadly was not able to recreate the bug. (It worked fine.) So there must be some other config in my project that's affecting this. If I have time I'll try to pin it down (already spent ~4 hours on this), but maybe someone who worked on the relevant patches can make an educated guess on what's happening?",Bug,closed,"Database layer (models, ORM)",1.11,Normal,needsinfo,,,Unreviewed,0,0,0,0,0,0