Re: DROP COLUMN - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: DROP COLUMN
Date
Msg-id GNELIHDDFBOCMGBFGEFOEECKCDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: DROP COLUMN  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: DROP COLUMN  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > 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.
>
> No, it will break all the places that need to see dropped columns.
>
> I agree that a wrapper function is probably an appropriate solution,
> but only some of the calls of SearchSysCache should use it.

What like add another parameter to SearchSysCache*?

Another question: How do I fill out the ObjectAddress when trying to drop
related objects?

eg:
       object.classId = ??;       object.objectId = ??;       object.objectSubId = ??;
  performDeletion(&object, behavior);

Chris



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] line datatype
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] CLUSTER not lose indexes