Bradley Baetz wrote: > <delurk - reading from the archives, so please cc me on responses> > > 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. 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. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html