Skip to main content
added 44 characters in body
Source Link
picardo
  • 24.9k
  • 33
  • 108
  • 154

I have created a migration to add a column named blurb to a table with only one other column called full_name. After I run my migrations, this new column appears to be added when I check from the database console of postgresql database, but not from the Rails app console. Then after a period of time, it vanishes from the postgresql console as well.

I don't know how to account for this. My migration was created using the rails migration generator and it's a :text field.

class AddBlurbToPeople < ActiveRecord::Migration
  def self.up
    add_column :people, :blurb, :text
  end

  def self.down
    remove_column :people, :blurb
  end
end

Any help would be much appreciated.

EDIT: PostgreSQL version number is 9.0.4

I have created a migration to add a column named blurb to a table with only one other column called full_name. After I run my migrations, this new column appears to be added when I check from the database console of postgresql database, but not from the Rails app console. Then after a period of time, it vanishes from the postgresql console as well.

I don't know how to account for this. My migration was created using the rails migration generator and it's a :text field.

class AddBlurbToPeople < ActiveRecord::Migration
  def self.up
    add_column :people, :blurb, :text
  end

  def self.down
    remove_column :people, :blurb
  end
end

Any help would be much appreciated.

I have created a migration to add a column named blurb to a table with only one other column called full_name. After I run my migrations, this new column appears to be added when I check from the database console of postgresql database, but not from the Rails app console. Then after a period of time, it vanishes from the postgresql console as well.

I don't know how to account for this. My migration was created using the rails migration generator and it's a :text field.

class AddBlurbToPeople < ActiveRecord::Migration
  def self.up
    add_column :people, :blurb, :text
  end

  def self.down
    remove_column :people, :blurb
  end
end

Any help would be much appreciated.

EDIT: PostgreSQL version number is 9.0.4

Source Link
picardo
  • 24.9k
  • 33
  • 108
  • 154

Rails migration issue with PostgreSQL

I have created a migration to add a column named blurb to a table with only one other column called full_name. After I run my migrations, this new column appears to be added when I check from the database console of postgresql database, but not from the Rails app console. Then after a period of time, it vanishes from the postgresql console as well.

I don't know how to account for this. My migration was created using the rails migration generator and it's a :text field.

class AddBlurbToPeople < ActiveRecord::Migration
  def self.up
    add_column :people, :blurb, :text
  end

  def self.down
    remove_column :people, :blurb
  end
end

Any help would be much appreciated.