[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ic] Bug in PostgreSQL support


Quoting SeattleServer.com (suppressed):
> 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_',
>         },

I will have to take your word for it, but I assume you are correct.

To this point, we have been saved by the fact that we don't actually
*use* this anywhere in Interchange. 8-) I think I put it in to anticipate
dynamic column type changes, but we never got there.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <suppressed>

In character, in manners, in style, in all things, the supreme excellence
is simplicity. -- Longfellow
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.