Re: BETWEEN Node & DROP COLUMN

Thomas Lockhart wrote:
> > Well in the renumbering case, the client needs to know about missing attnos
> > and it has to know to ignore negative attnos (which it probably does
> > already).  ie. psql and pg_dump wouldn't have to be modified in that case.
> > In the isdropped case, the client needs to know to exclude any column with
> > 'attisdropped' set to true.
> > So in both cases, the client needs to be updated.
> 
> How about defining a view (or views) which hides these details? Perhaps
> a view which is also defined in SQL99 as one of the information_schema
> views which we might like to have anyway?

We could change pg_attribute to another name, and create a view called
pg_attribute that never returned isdropped columns to the client.  That
would allow clients to work cleanly, and the server to work cleanly.

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