Re: [GENERAL] How can i delete large objects from DB?

From: Dustin Sallings <dustin(at)spy(dot)net>
To: "Sergei M(dot) Suntsov" <serge(at)uic(dot)nsu(dot)ru>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] How can i delete large objects from DB?
Date: 1998-08-04 00:47:25
Message-ID: ML-3.5-SPY.902191645.3010.dustin@bleu.west.spy.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Man page on large objects describes how to create one, from file wit
> lo_import, etc. But if i want delete row from the table which references
> large object should I delete large object also? How can it be done ?

Well, BLOBs aren't actually stored *in* tables, but you could do a
trigger mechanism that says ``if someone deletes something from this table, do
this'' ...this being, ``lo_unlink(that blob)''

--
SA, software.net My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 1998-08-04 03:15:19 CD Distribution/Rates changed...
Previous Message Dustin Sallings 1998-08-04 00:34:49 Re: [GENERAL] lo_import() problem