Re: BETWEEN Node & DROP COLUMN - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: BETWEEN Node & DROP COLUMN
Date
Msg-id 3D23DFCC.A828F4A@fourpalms.org
Whole thread Raw
In response to Re: BETWEEN Node & DROP COLUMN  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: BETWEEN Node & DROP COLUMN
List pgsql-hackers
> 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?
                   - Thomas




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BETWEEN Node & DROP COLUMN
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] [SQL] pg_restore cannot restore function