Create a gist now

Instantly share code, notes, and snippets.

ar / pg / bytea is fucked on heroku due to db config
>> escaped = ActiveRecord::Base.connection.raw_connection.query("select 'foobar'::bytea").first.values.first
=> "\\x666f6f626172"
>> PGconn.unescape_bytea(escaped)
=> "x666f6f626172"
>> ActiveRecord::VERSION::STRING
=> "2.3.5"a
[47] pry(#<PostgresqlByteaTest>)> escaped = ActiveRecord::Base.connection.raw_connection.query("select 'foobar'::bytea").values[0][0]
=> "\\x666f6f626172"
[48] pry(#<PostgresqlByteaTest>)> PGconn.unescape_bytea(escaped)
=> "foobar"
[49] pry(#<PostgresqlByteaTest>)> ActiveRecord::VERSION::STRING
=> "4.0.0.beta"

Are you using the same version of the pg gem?


no. but that's not the issue. the actually call to PGconn.unescape_bytea returns different values on heroku even with the same versions. odd!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment