Rails - Apr 2012 - SQLite3 to Postgre Problem

Hi, guys. I''ve got my app running on my machine, but when I upload to
git I get the following:

Migrating to CreateUsers (20120408201839)
Migrating to AddIndexToUsersEmail (20120417073358)
Migrating to AddPasswordDigestToUsers (20120418010408)
Migrating to AddRememberTokenToUsers (20120419082857)
Migrating to AddAdminToUsers (20120420011332)
Migrating to CreateAppointments (20120424081820)
Migrating to AddUserToAppointments (20120426121458)
Migrating to AdjustUserTable (20120426153043)
Migrating to AdjustUserTable2 (20120426163329)
Migrating to ChageDataTypeOfData (20120427104706)
==  ChageDataTypeOfData: migrating
===========================================-- change_table(:appointments)
rake aborted!
An error has occurred, this and all later migrations canceled:

PGError: ERROR:  relation "appointments" does not exist
: ALTER TABLE "appointments" ALTER COLUMN "date" TYPE date

Tasks: TOP => db:migrate
(See full trace by running task with --trace)

I assume that it is due to some inconsistency between SQLite and
Postgre, but I am not sure how to go about fixing it. I will continue
looking for the answer, but if anyone can point me in the right
direction, I will be thankful.

-- 
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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

The error message is telling you the problem:

    relation "appointments" does not exist 

Can you post the contents of your CreateAppointments migration file?
I''m
assuming this is where the appointments table should be created.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/ok0VP8B5yr4J.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.