Seeding db caused script error

Support Ticket

+status
+tags
 

PGError: ERROR:  column "trash" is of type boolean but expression is of type integer

USING postgres 9.1

Changed the schema.rb file trash to type integer fixed the problem

 

 

I think we're having this problem because the fixtures were dumped from mysql, which treats booleans as tiny integers.

 

Your solution is clever but may cause you some problems in the future.  Perhaps you can alter the column back to a boolean?


I think we need to tweak the bootstrap dumping here:

file.write YAML::dump( data.inject({}) { |hash, record|

hash["#{table}_#{i.succ!}"] = record

hash

})

  --Ethan McCutchen.....2012-11-09 18:05:29 +0000


this has been addressed in a more durable way in our data generation

  --Ethan McCutchen.....2013-03-13 01:30:00 +0000