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]> 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]. > > 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]<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.
