How do I drop all tables if db:reset isn't supported? I want to start over with migrations, but I'm getting an error when I try.
On Wed, Nov 24, 2010 at 2:37 PM, Josh Coffman <[email protected]> wrote: > Yep, and I was considering dropping everything and trying again. But I dont > think it will matter. > > > On Wed, Nov 24, 2010 at 1:18 PM, José <[email protected]> wrote: > >> I suppose you executed rake db:migrate, right? >> >> >> >> El 24/11/2010, a las 18:54, Josh Coffman <[email protected]> >> escribió: >> >> Makes sense, so I added a migration to change those columns to text. But >> it didn't seem to change schema.rb. Is this because I'm using sqlite3 >> locally? I tried to update and push to heroku and still got the same error. >> >> -j >> >> On Wed, Nov 24, 2010 at 10:10 AM, Steve Smith < <[email protected]> >> [email protected]> wrote: >> >>> Hi Josh, >>> >>> It looks like one of your string fields is too long for the 255 character >>> limit imposed by postgres. You could maybe try migrating to text rather than >>> string or truncate the value locally? >>> >>> Steve >>> >>> >>> On 24 Nov 2010, at 17:05, Josh Coffman wrote: >>> >>> > Howdy! >>> > >>> > I'm trying to push data from my local sqlite3 up to heroku, but its >>> failing. Can someone tell me what I'm doing wrong? (calline heroku db:push >>> --app <name-of-app>) >>> > >>> > It's a long error; here's the top: >>> > Saving session to push_201011240903.dat.. >>> > !!! Caught Server Exception >>> > HTTP CODE: 500 >>> > Taps Server Error: PGError: ERROR: value too long for type character >>> varying(255) >>> > >>> > >>> ["/home/app/0e1a0bef-5a14-40a0-9eee-030aa94c4859/.gems/gems/sequel-3.15.0/lib/sequel/adapters/postgres.rb:162:in >>> `async_exec'", >>> "/home/app/0e1a0bef-5a14-40a0-9eee-030aa94c4859/.gems/gems/sequel-3.15.0/lib/sequel/adapters/postgres.rb:162:in >>> `block (2 levels) in execute'", >>> "/home/app/0e1a0bef-5a14-40a0-9eee-030aa94c4859/.gems/gems/sequel-3.15.0/lib/sequel/database/logging.rb:23:in >>> `log_yield'", >>> "/home/app/0e1a0bef-5a14-40a0-9eee-030aa94c4859/.gems/gems/sequel-3.15.0/lib/sequel/adapters/postgres.rb:162:in >>> `block in execute'", "/home/app/0e1a0bef......... >>> > >>> > >>> > TIA, >>> > Josh >>> > >>> > >>> > -- >>> > You received this message because you are subscribed to the Google >>> Groups "Heroku" group. >>> > To post to this group, send email to <[email protected]> >>> [email protected]. >>> > To unsubscribe from this group, send email to >>> <heroku%[email protected]> >>> [email protected]. >>> > For more options, visit this group at >>> <http://groups.google.com/group/heroku?hl=en> >>> http://groups.google.com/group/heroku?hl=en. >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Heroku" group. >>> To post to this group, send email to <[email protected]> >>> [email protected]. >>> To unsubscribe from this group, send email to >>> <heroku%[email protected]> >>> [email protected]. >>> For more options, visit this group at >>> <http://groups.google.com/group/heroku?hl=en> >>> http://groups.google.com/group/heroku?hl=en. >>> >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "Heroku" 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/heroku?hl=en. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Heroku" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<heroku%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/heroku?hl=en. >> > > -- You received this message because you are subscribed to the Google Groups "Heroku" 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/heroku?hl=en.
