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