Christopher Kings-Lynne wrote: > > > If the client has to bear the some part, isn't the invisible > > column approach much simpler ? > > > > I've put a pretty much time into DROP COLUMN feature but > > I am really disappointed to see the comments in this thread. > > What DROP COLUMN has brought me seems only a waste of time. > > I kind of agree with Hiroshi here. All I want to be able to do is drop > columns from my tables, and reclaim the space. I've got all sorts of > production tables with columns just sitting there doing nothing, awaiting > the time that I can happily drop them.
> It seems to me that whatever we do > will require some kind of client breakage. Physical/logical attnum approach was mainly to not break clients. I implemented it on trial but the implementation was hard to maintain unfortunately. It's pretty difficult to decide whether the number is physical or logical in many cases. regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org