Re: AW: AW: [HACKERS] ALTER TABLE DROP COLUMN

2000-10-17 Thread Hiroshi Inoue
Zeugswetter Andreas SB wrote: > > This style of "DROP COLUMN" would change the attribute > > numbers whose positons are after the dropped column. > > Unfortunately we have no mechanism to invalidate/remove > > objects(or prepared plans) which uses such attribute numbers. > > And I've seen no pro

Re: AW: AW: [HACKERS] ALTER TABLE DROP COLUMN

2000-10-16 Thread Hiroshi Inoue
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> This said, I think Hiroshi's patch seems a perfect starting point, no ? > > > Having phantom columns adds additional complexity to the system overall. > > We have to decide we really want it before making things more complex > > th

Re: AW: AW: [HACKERS] ALTER TABLE DROP COLUMN

2000-10-13 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: >> This said, I think Hiroshi's patch seems a perfect starting point, no ? > Having phantom columns adds additional complexity to the system overall. > We have to decide we really want it before making things more complex > than they already are. I think

Re: AW: AW: [HACKERS] ALTER TABLE DROP COLUMN

2000-10-13 Thread The Hermit Hacker
On Fri, 13 Oct 2000, Bruce Momjian wrote: > [ Charset ISO-8859-1 unsupported, converting... ] > > > we bite the bullet to the extent of supporting a distinction between > > > physical and logical column numbers, then ISTM there's no strong need > > > to do any of this other stuff at all. I'd exp

Re: AW: AW: [HACKERS] ALTER TABLE DROP COLUMN

2000-10-13 Thread Bruce Momjian
[ Charset ISO-8859-1 unsupported, converting... ] > > we bite the bullet to the extent of supporting a distinction between > > physical and logical column numbers, then ISTM there's no strong need > > to do any of this other stuff at all. I'd expect that an inserted or > > updated tuple would hav