Skip site navigation (1) Skip section navigation (2)

are BLOBs deleted that are not referenced?

From: David Wetzel <dave(at)turbocat(dot)de>
To: pgsql-hackers(at)postgreSQL(dot)org, pgsql-ports(at)postgreSQL(dot)org
Subject: are BLOBs deleted that are not referenced?
Date: 1998-07-03 09:28:08
Message-ID: 199807030928.LAA00621@cat.turbocat.de (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

are BLOBs deleted that are not referenced any more?

Imagine, I have a table with a column

  | text   | oid  |     4 |

when this row is deleted, will postgres throw the BLOB away?

---
   _  _
 _(_)(_)_  David Wetzel, Turbocat's Development,
(_) __ (_) Buchhorster Strasse, D-16567 Muehlenbeck/Berlin, FRG,
  _/  \_   Fax +49 33056 82835 NeXTmail dave(at)turbocat(dot)de
 (______)  http://www.turbocat.de/
           DEVELOPMENT * CONSULTING * ADMINISTRATION

Responses

pgsql-hackers by date

Next:From: Sferacarta SoftwareDate: 1998-07-03 10:02:13
Subject: Access & Postgres
Previous:From: Maarten BoekholdDate: 1998-07-03 07:44:24
Subject: Re: [HACKERS] no answer to Solaris 2.6 failure to build 6.3.2?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group