Heroku / Postgres Error: integer out of range

Question

I am getting PGError: ERROR: integer out of range message from trying to insert the following integer: 100001389928198.

According to the Postgres docs on numeric datatypes the limit is much higher (9223372036854775807). I have a feeling Heroku is treating the column as a regular integer rather than a BIGINT.

I defined the migration as a BIGINT as such:

t.column :uid, :bigint

is this not correct in terms of Heroku migrations?

I see. So I guess we will start using these larger int fields now. — port5432
– port5432, Commented Dec 31, 2012 at 7:59

YOU · Accepted Answer · 2011-08-25 17:50:58Z

9

I am not sure t.column is same as change_column or not, but here is how according to api

change_column :table_name, :uid, :bigint

answered Aug 25, 2011 at 17:50

YOU

124k34 gold badges191 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

neon Over a year ago

my original migration was as stated above, but running this one did the trick. thanks!

Kevin Davis Over a year ago

this worked for me too.. surprising given that :bigint isn't listed as one of the column types in the migrations guide and that :limit => 8 seemed to work for me on pg locally..

Mark Locklear Over a year ago

Hmm...I tried this and got the error undefined method `bigint' for #<ActiveRecord::ConnectionAdapters::PostgreSQLAdapter::TableDefinition:0x000000045beb50> Ended up doing t.integer :field, :limit => 8 instead to limit the size.

Collectives™ on Stack Overflow

Heroku / Postgres Error: integer out of range

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related