Re: DROP COLUMN

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: DROP COLUMN
Дата
Msg-id GNELIHDDFBOCMGBFGEFOEECKCDAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: DROP COLUMN  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: DROP COLUMN  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] line datatype
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] CLUSTER not lose indexes