altre table and large object deletion

Started by Jeremiah Jahnover 21 years ago2 messagesgeneral
Jump to latest
#1Jeremiah Jahn
jeremiah@cs.earlham.edu

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>

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Jeremiah Jahn (#1)
Re: altre table and large object deletion

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