This project is archived and is in readonly mode.

#1700 ✓invalid
Don Park

Postgresql Adapter not identifying binary column

Reported by Don Park | January 5th, 2009 @ 09:49 PM | in 2.x


Association => Association(id: integer, server_url: , handle: string, secret: , issued: integer, lifetime: integer, assoc_type: string)

notice the "server_url" and "secret" column does not know its type. (they are both bytea/binary columns)

(ruby 1.8.7) Loading development environment (Rails 2.2.2)

ActiveRecord::Base.connection.class => ActiveRecord::ConnectionAdapters::PostgreSQLAdapter

ActiveRecord::Base.connection.columns("open_id_associations") => [#<ActiveRecord::ConnectionAdapters::Column:0xb6d40d30

Notice the class is a Column instead of a PostgreSQLColumn. when i try to save an Assocation model, postgresql throws an encoding error. Since the column type is not identified, AR is not escaping the data for that column.

Comments and changes to this ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

<h2 style="font-size: 14px">Tickets have moved to Github</h2>

The new ticket tracker is available at <a href=""></a>

People watching this ticket