diff options
| -rw-r--r-- | activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb | 5 | ||||
| -rw-r--r-- | activerecord/test/migration_test.rb | 9 |
2 files changed, 12 insertions, 2 deletions
diff --git a/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb b/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb index 60e258c76a..6b2e5d21c4 100644 --- a/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb +++ b/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb @@ -587,13 +587,14 @@ module ActiveRecord execute "ALTER TABLE #{name} RENAME TO #{new_name}" end - # Adds a column to a table. + # Adds a new column to the named table. + # See TableDefinition#column for details of the options you can use. def add_column(table_name, column_name, type, options = {}) default = options[:default] notnull = options[:null] == false # Add the column. - execute("ALTER TABLE #{quote_table_name(table_name)} ADD COLUMN #{quote_column_name(column_name)} #{type_to_sql(type, options[:limit])}") + execute("ALTER TABLE #{quote_table_name(table_name)} ADD COLUMN #{quoted_column_name} #{type_to_sql(type, options[:limit], options[:precision], options[:scale])}") change_column_default(table_name, column_name, default) if options_include_default?(options) change_column_null(table_name, column_name, false, default) if notnull diff --git a/activerecord/test/migration_test.rb b/activerecord/test/migration_test.rb index f2683f3aef..f98f094fea 100644 --- a/activerecord/test/migration_test.rb +++ b/activerecord/test/migration_test.rb @@ -268,6 +268,15 @@ if ActiveRecord::Base.connection.supports_migrations? Person.reset_column_information end + def test_add_column_with_precision_and_scale + Person.connection.add_column 'people', 'wealth', :decimal, :precision => 9, :scale => 7 + Person.reset_column_information + + wealth_column = Person.columns_hash['wealth'] + assert_equal 9, wealth_column.precision + assert_equal 7, wealth_column.scale + end + def test_native_types Person.delete_all Person.connection.add_column "people", "last_name", :string |