Thread: altre table and large object deletion

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>

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