I have a schema for my postgres DB that uses a String for an id. The  
table definition is as follows:

        Column                  |         Type                                  
| Modifiers

  id                                    | character varying(50)         | not 
null
  default_syllabus_id   | integer                                       |

My current development database has the following entries for this  
table:

    id          | default_syllabus_id
  config        |                   1
(1 row)

When I try to push this to heroku using heroku db:push, I get the  
following error:

!!! Caught Server Exception                                    | ETA:   
--:--:--
Taps Server Error: PGError ERROR:  invalid input syntax for integer:  
"config"

However, if I run:

heroku rake db:reset
heroku rake db:migrate
heroku rake db:populate # a custom task that creates the same data  
entries as above (as well as other data)

then all is well and my application works fine.

So, it would appear that something in taps can't cope with the non- 
integer ID, even though PG can.

As I mention above, I have a workaround, but would appreciate any  
feedback on how this might be addressed so that I _can_ use heroku  
db:push, or even where else I should report the 'bug' in taps.

Thanks,

Andy
o-- CLLEARVIEW





--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to