Re: What happens if you delete a row containing a BLOB?

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Terrence Brannon" <metaperl(at)mac(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: What happens if you delete a row containing a BLOB?
Date: 2001-12-17 02:44:23
Message-ID: GNELIHDDFBOCMGBFGEFOAENCCAAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> If you delete a row with a BLOB, does it automatically lo_unlink
> the blob?

No, I believe it does not - you need to run an 'lo_delete' command
separately. In Postgres 7.1+ though, I think it's easier to just use the
'bytea' binary large string type. It's there in 7.1, but 7.2 has introduced
many new operators for it.

Chris

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message MindTerm 2001-12-17 02:58:56 Re: performance tuning in large function / transaction
Previous Message Marc Spitzer 2001-12-17 02:01:06 Re: persistent connections, AOLserver (Was: maybe Offtopic :