AW: AW: ALTER TABLE DROP COLUMN - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: AW: ALTER TABLE DROP COLUMN
Date
Msg-id 11C1E6749A55D411A9670001FA6879633680A8@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> 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 proposal/discussion to solve this problem
> for DROP COLUMN feature. We wound't be able to prevent
> PostgreSQL from doing the wrong thing silently. 

That issue got me confused now (There was a previous mail where 
you suggested using logical colid most of the time). Why not use the 
physical colid in prepared objects/plans. Since those can't currently change
it seems such plans would not be invalidated.

Andreas


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: AW: ALTER TABLE DROP COLUMN
Next
From: Franck Martin
Date:
Subject: bytea type