mini_record
mini_record copied to clipboard
PostgreSQL booleans not supported
In auto_upgrade! if you choose a field with type :boolean it will call
connection.add_column table_name, column.name, column.type.to_sym, options
However, options will include :limit => 1 and in turn it will cause a query to PostgreSQL looking like
SELECT 'boolean(1)'::regtype::oid instead of the correct SELECT 'boolean'::regtype::oid.
I have a fix for this, but I am also working out some other issues with PostgreSQL and mini_record.
Basically to fix it you can add options[:limit] = nil if column.type.to_sym == :boolean && defined?(ActiveRecord::ConnectionAdapters::PostgreSQLAdapter) && connection.is_a?(ActiveRecord::ConnectionAdapters::P ostgreSQLAdapter)