From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Danny Rice <dwrice(at)indiana(dot)edu> |
Cc: | Rostislav Matl <xmatl(at)informatics(dot)muni(dot)cz>, pgsql-sql(at)postgresql(dot)org |
Subject: | RE: [SQL] data larger than 8k |
Date: | 1998-07-19 09:40:51 |
Message-ID: | Pine.LNX.3.96.980719103936.3339H-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Sat, 18 Jul 1998, Danny Rice wrote:
> create table test (name text, filename oid);
> insert into test values ( 'a file', lo_import('/tmp/afile') );
>
> will create database files named as xinv(BigInteger) and
> xinx(BigInteger).
>
> When I do
>
> delete from test;
> or
> drop table test;
>
> These xin files stay around. Is there a way to have these cleaned up
> on delete and drop?
This is a work in progress. In the developer source, take a look in
contrib/lo which defines a new type 'lo' which handles large object
orphaning. It can handle 'delete from test' but not 'drop table test'.
--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1998-07-19 10:24:32 | Re: [SQL] Change attribute type |
Previous Message | Jerome Knobl | 1998-07-19 06:04:24 | unsubscribe |