Обсуждение: altre table and large object deletion

Поиск
Список
Период
Сортировка

altre table and large object deletion

От
Jeremiah Jahn
Дата:
will an alter table that removes an oid type also remove all of the
associated large objects. I've been using blobs but have converted to
byte arrays, now I need to get rid of all of the blobs. Will this be
enough? followed by a vaccum of course.


--
Jeremiah Jahn <jeremiah@cs.earlham.edu>


Re: altre table and large object deletion

От
Tom Lane
Дата:
Jeremiah Jahn <jeremiah@cs.earlham.edu> writes:
> will an alter table that removes an oid type also remove all of the
> associated large objects.

No, but see contrib/vacuumlo.

            regards, tom lane