Re: DROP COLUMN

Rod Taylor wrote:
> On Mon, 2002-07-15 at 11:30, Christopher Kings-Lynne wrote:
> > OK, more DROP COLUMN funny business:
> > 
> > Assuming that selects, updates and deletes all ignore the dropped column,
> > what happens with things like alter table statements?
> > 
> > You can still quite happily set the default for a dropped column, etc.
> > 
> > Will I have to add a dropped column check in everywhere that a command is
> > able to target a column.  ie. create index, cluster, alter table, etc,
> > etc.?  Or is there an easier way?
> 
> Each utility statement does some kind of a SearchSysCache() to determine
> the status of the column (whether it exists or not).
> 
> You may want to write a wrapper function in lsyscache.c that returns the
> status of the column (dropped or not).  Perhaps the att tuple could be
> fetched through this function (processed on the way out) -- though
> lsyscache routines tend to return simple items.

Excellent idea.  That's how temp tables worked, by bypassing the
syscache.  I wonder if you could just prevent dropped columns from being
returned by the syscache.  That may work just fine.

--  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