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) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---