talltroym/cfwheels-dbmigrate-plugin — Issue #44: Postgres - AddColumnOptions
Author: malpaso
Created: 2012-01-01 06:00:21+00:00
State: open

The 'AddColumnOptions' in Abstract.cfc needs to be copied into the PostgreSQL.cfc and the following changed:

'''} else if(arguments.options.type == 'boolean') {
arguments.sql = arguments.sql & " DEFAULT #IIf(arguments.options.default,1,0)#";'''

to

'''} else if(arguments.options.type == 'boolean') {
arguments.sql = arguments.sql & " DEFAULT #IIf(arguments.options.default,de('true'),de('false'))#";'''