Forum OpenACS Q&A: Response to v3.2.4 ecommerce custom fields functionality broken

Edmun:

Actually i think you don't have to port the drop column statement.

If you wrap both column creations (in one table and in its audit table) , and there's something wrong, the transaction will be aborted and none will be created, so you don't need to drop them explicity.

Could anybody correct me if i'm wrong?

Anyway, i've ported it, but i haven't tested it deep enough. I can send a copy of custom-field-add-3.tcl to anybody interested.

Some days later, i will clean it and send it to Roberto (i'm in the middle of a project right now).

What i haven't been able to port is the "alter data type" statement. I think that's not possible in PostgreSQL. Does anybody know about it?