Re: [HACKERS] Well, then you keep your darn columns

Поиск
Список
Период
Сортировка
От Ed Loehr
Тема Re: [HACKERS] Well, then you keep your darn columns
Дата
Msg-id 388CB580.6B336648@austin.rr.com
обсуждение исходный текст
Ответ на RE: [HACKERS] Well, then you keep your darn columns  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Ответы Re: [HACKERS] Well, then you keep your darn columns  (Don Baccus <dhogaza@pacifier.com>)
Список pgsql-hackers
Don Baccus wrote:
> 
> >How would you handle multi-column indices that included the column
> >being dropped?  E.g.,
> >
> >       create unique index foobar on mytable(foo,bar);
> >
> >where the 'bar' column is then dropped...
> 
> ...  Oracle drops all indices which reference the column.

Seems like a new 'gotcha'... either way, informative warnings/notices
would be nice.

Along these same lines, how would pre-existing functions that
referenced the just-dropped column be handled?  I'm thinking of
PL/pgSQL...


Cheers,
Ed Loehr


В списке pgsql-hackers по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] Well, then you keep your darn columns
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] Well, then you keep your darn columns