Re: BLOB question + MS Access ODBC issue - Mailing list pgsql-general

From Tom Lane
Subject Re: BLOB question + MS Access ODBC issue
Date
Msg-id 8648.1011381242@sss.pgh.pa.us
Whole thread Raw
In response to BLOB question + MS Access ODBC issue  (jan@evation.com (Jan Branbergen))
List pgsql-general
jan@evation.com (Jan Branbergen) writes:
> in the proces of porting the data, i have created a lot of BLOBs, and
> in the next import run, i truncated the table which was referencing
> the BLOB ( so i did not do a pg_lounlink for the object ).

> this has happened numerous times, so i a worried about the following:
> have the BLOBs become "zombie"-BLOBs ( that is: are they still
> residing in my database ), or are they deleted with a VACUUM for
> example? i could not find this is in the manual.

They're zombies.  See the contrib/vacuumlo program for some help
cleaning them out.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: "IS NOT NULL" != "NOT NULL"
Next
From: "Peter Bayley"
Date:
Subject: Recover an existing database