> > Note that before bugzilla really supports postgresql, we (ie > the bugzilla > > team) are going to need DROP COLUMN support, as well as support for > > changing a field's type. This is because thats how upgrades are > done, when > > new features change the bz schema. > > DROP COLUMNS should be in 7.3, due out in the Fall.
Assuming, of course, that I can get past these latest problems that Tom brought up - otherwise I guess I could pass it off again :( > You can simulate > ALTER COLUMN by creating a new column, UPDATING the data to the new > column, dropping the old, then renaming the new column to the old name. Well, once DROP COLUMN is natively supported, I intend to implement a SET TYPE or MODIFY function - it should be quite straightforward once DROP COLUMN is done. It will maintain all foreign key and index references properly... Chris ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
