# "Multiple default values" with Rails migration

**URL:** <https://www.ruby-forum.com/t/multiple-default-values-with-rails-migration/123125>\
**Category:** Rails\
**Created:** [December 14, 2007, 7:43am UTC](https://www.ruby-forum.com/t/multiple-default-values-with-rails-migration/123125 "2007-12-14T07:43:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![chirag](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/ecccb3/32.png) [@chirag](https://www.ruby-forum.com/u/chirag)\
**Post date:** [December 14, 2007, 7:43am UTC](https://www.ruby-forum.com/t/multiple-default-values-with-rails-migration/123125/1 "2007-12-14T07:43:32Z")

</div>

I am running the following migration with PostgreSQL 8.2.5. It works  
fine on my Windows machine, but gives me the below error on Linux  
CentOS 4.3. Any ideas? Thanks, Chirag

class CreateUsers \< ActiveRecord::Migration  
def self.up  
create\_table :uers do |t|  
t.column :timestamp, :timestamp\_with\_time\_zone  
t.column :userval, :integer, :limit =\> 1, :null=\> false #will  
use smallint becuase of plug-in  
end  
end

def self.down  
drop\_table :users  
end  
end

# == CreateUsers: migrating

– create\_table(:users)  
rake aborted!  
RuntimeError: ERROR C42601 Mmultiple default values specified for  
column “id” of table “users” Fanalyze.c L1216  
RtransformColumnDefinition: CREATE TABLE users (“id” serial primary  
key DEFAULT NULL, “user\_id” integer DEFAULT NULL, “timestamp” integer  
DEFAULT NULL, “userval” smallint NOT NULL)

(See full trace by running task with --trace)