John-paul,
> How do I change a column from date type to text?
This functionality is not supported in version 7.2 or earlier. You
will have to drop and re-create the table:
1. CREATE TABLE temp1 AS
SELECT * FROM bad_table;
2. DROP TABLE bad_table;
3. CREATE TABLE bad_table;
4. INSERT INTO bad_table SELECT * FROM temp1;
5. DROP TABLE temp1
-Josh Berkus