altre table and large object deletion

#1

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 (AT) cs (DOT) earlham.edu>

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

#2

Jeremiah Jahn <jeremiah (AT) cs (DOT) earlham.edu> writes:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

altre table and large object deletion

comp.databases.postgresql.general comp.databases.postgresql.general

altre table and large object deletion - 11-19-2004 , 12:58 PM

Re: altre table and large object deletion - 11-19-2004 , 02:06 PM