mini_record icon indicating copy to clipboard operation
mini_record copied to clipboard

PostgreSQL booleans not supported

Open burnt43 opened this issue 8 years ago • 1 comments

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.

burnt43 avatar Feb 27 '17 18:02 burnt43

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)

burnt43 avatar Feb 27 '17 18:02 burnt43