Hi,
I'm using Rails v2.3.2 with a PostgreSQL database and I needed a column to hold very large integers. Defining a migration such as:
create_table :large_integers do |t| t.decimal :large, :scale => 0, :precision => 80
t.timestamps end
Gave me a numeric(40, 0) column which was exactly what I wanted. However, after running the schema dumper, db/schema.rb contained the following:
create_table "large_integers", :force => true do |t| t.integer "large", :limit => 80, :precision => 80, :scale => 0 t.datetime "created_at" t.datetime "updated_at" end
Unfortunately, this creates a plain integer column, which can not hold numbers this large.
I've created a patch to fix this problem in the schema dumper, and it's attached to Lighthouse ticket #2741:
Could someone please review this patch?
Thanks, Giles