Forum OpenACS Q&A: Response to How to drop a column in postgres ?

Collapse
Posted by Dan Wickstrom on
You have to be careful with this approach, as it will drop all of the foreign key constraints and triggers associated with this table.  When I do this, if I know that the table has associated foreign key constraints, I do a before and after dump and compare them to make sure that I added the foreign key constraints back correctly.