Postgres Pro
Downloads
Home   >   mailing lists

Re: What happens if you delete a row containing a BLOB? - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: What happens if you delete a row containing a BLOB?
Date
Msg-id GNELIHDDFBOCMGBFGEFOAENCCAAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to What happens if you delete a row containing a BLOB?  (Terrence Brannon <metaperl@mac.com>)
List pgsql-sql
Tree view 
> 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

pgsql-sql by date:

Previous
From: marc@oscar.eng.cv.net (Marc Spitzer)
Date:
Subject: Re: persistent connections, AOLserver (Was: maybe Offtopic :
Next
From: MindTerm
Date:
Subject: Re: performance tuning in large function / transaction