OK, I finally got Postgres server installed and running in Windows using the new "pg" adapter gem.
http://rubygems.org/gems/pg I suspect that trying out you app locally on Postgres before moving to Heroku might relieve some debugging headaches. Of course, we need to find out what the latest PostgreSQL driver is being used by Heroku so we can match our local code. I am suspecting there is some Postgres indexing "magic" going on behind the scenes that are tripping us up with the new Hobo indexgen that came in 1.0. Need more exploration... Next step is to gen a more complex app to see where indexing may get tripped up... On May 16, 11:32 pm, Owen <[email protected]> wrote: > I got the app running locally on SQLite3, but when I run ">heroku rake > db:Migrate" I see this error from Postgres (the DB used on Heroku) > > new-host:wurmi-guild owendall$ heroku rake db:migrate > rake aborted! > An error has occurred, this and all later migrations canceled: > > PGError: ERROR: current transaction is aborted, commands ignored > until end of transaction block > : CREATE INDEX "index_chars_on_owner_id" ON "chars" ("owner_id") > > (See full trace by running task with --trace) > (in /disk1/home/slugs/187306_4653f03_c2e7/mnt) > == HoboMigration1: migrating > ================================================= > -- create_table(:users) > -> 0.0208s > -- add_index(:users, [:state]) > -> 0.0119s > -- create_table(:chars) > -> 0.0117s > == HoboMigration1: migrated (0.0447s) > ======================================== > > == HoboMigration2: migrating > ================================================= > -- add_column(:chars, :server, :string) > -> 0.0023s > -- add_column(:chars, :guild, :string) > -> 0.0022s > -- add_column(:chars, :fraction, :string) > -> 0.0023s > -- add_column(:chars, :dclass, :string) > -> 0.0021s > -- add_column(:chars, :race, :string) > -> 0.0022s > -- add_column(:chars, :likings, :string) > -> 0.0022s > -- add_column(:chars, :user_id, :integer) > -> 0.0023s > -- remove_column(:chars, :wclass) > -> 0.0023s > -- remove_column(:chars, :wfraction) > -> 0.0021s > -- remove_column(:chars, :orientation) > -> 0.0021s > -- remove_column(:chars, :wrace) > -> 0.0021s > -- add_index(:chars, [:user_id]) > -> 0.0049s > == HoboMigration2: migrated (0.0301s) > ======================================== > > == HoboMigration3: migrating > ================================================= > -- add_column(:chars, :owner_id, :integer) > -> 0.0024s > -- remove_column(:chars, :user_id) > -> 0.0028s > -- remove_index(:chars, {:name=>:index_chars_on_user_id}) > -- add_index(:chars, [:owner_id]) > new-host:wurmi-guild owendall$ > > -- > You received this message because you are subscribed to the Google Groups > "Hobo Users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/hobousers?hl=en. -- You received this message because you are subscribed to the Google Groups "Hobo Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/hobousers?hl=en.
