What is default integer limit in PostrgreSQL database for Rails 3?

Question

That's the question.

You just want to know what integer range is valid? – Larsenal Sep 29 '11 at 18:36 — Larsenal, Sep 29 '11 at 18:36

score 7 · Accepted Answer · edited Nov 05 '15 at 20:48

7

By default, Rails will use PostgreSQL's integer type, which has a range of -2147483648 to +2147483647.

edited Nov 05 '15 at 20:48

Community

answered Sep 29 '11 at 18:12

Larsenal

Can you get it to use a bigint? That's 2^63-1 max. – Scott Marlowe Sep 29 '11 at 20:03
@ScottMarlowe This is an old question, but here's a link that shows how to change the column type for Rails: http://stackoverflow.com/questions/7061239/rails-migration-bigint-on-postgresql-seems-to-be-failing – Nick Feb 01 '16 at 14:06

1 Answers1