will an alter table that removes an oid type also remove all of theassociated large objects. I've been using blobs but have converted tobyte arrays, now I need to get rid of all of the blobs. Will this beenough? 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 theassociated large objects.
No, but see contrib/vacuumlo.
regards, tom lane