[ic] Bug in PostgreSQL support

SeattleServer.com lists at seattleserver.com
Wed Oct 18 00:04:54 EDT 2006


PostgreSQL is not broken like MySQL.  Thus, this is incorrect in 
lib/Vend/Table/DBI.pm:

        ALTER_CHANGE => {
                mysql => 'ALTER TABLE _TABLE_ CHANGE COLUMN _COLUMN_ _COLUMN_ 
_DEF_',
                Pg => 'ALTER TABLE _TABLE_ CHANGE COLUMN _COLUMN_ _COLUMN_ 
_DEF_',
        },

I'm guessing this is correct based on what CHANGE COLUMN does in MySQL:

        ALTER_CHANGE => {
                mysql => 'ALTER TABLE _TABLE_ CHANGE COLUMN _COLUMN_ _COLUMN_ 
_DEF_',
                Pg => 'ALTER TABLE _TABLE_ ALTER COLUMN _COLUMN_ TYPE TO 
_DEF_',
        },

Cheers,
-- 
SeattleServer.com Mailing Lists - Casey Allen Shobe
lists at seattleserver.com - http://seattleserver.com


More information about the interchange-users mailing list