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 her...@googlegroups.com. > To unsubscribe from this group, send email to > heroku+unsubscr...@googlegroups.com. > 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 her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
