Re: [INTERFACES] [pgaccess-users] RE: bugzilla.pgaccess.org

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 pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026