pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Danny Rice <dwrice@indiana.edu>
To: Rostislav Matl <xmatl@informatics.muni.cz>
Cc: pgsql-sql@postgreSQL.org
Subject: RE: [SQL] data larger than 8k
Date: Sat, 18 Jul 1998 19:43:00 +0200 (DST)
Message-ID: <13744.56996.353223.158765@siren.bio.indiana.edu> (raw)
In-Reply-To: <199807161658.SAA15445@aisa.fi.muni.cz>
References: <13742.11506.902372.667917@siren.bio.indiana.edu>
	<199807161658.SAA15445@aisa.fi.muni.cz>

 > 
 > On 16-Jul-98 Danny Rice wrote:
 > > 
 > > If a table element can only handle up to 8k of data what do you do if
 > > you need to insert larger data?
 > 
 > Rostislav Matl writes:
 > Use large_objects - it's in man pages.

Thanks,

I noticed that

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?

-- 
Danny Rice



view thread (4+ messages)  latest in thread

Message-ID: <13744.56996.353223.158765@siren.bio.indiana.edu>
Permalink:  ../13744.56996.353223.158765@siren.bio.indiana.edu/
Also on:    postgresql.org/message-id/13744.56996.353223.158765@siren.bio.indiana.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: dwrice@indiana.edu, xmatl@informatics.muni.cz
  Subject: Re: [SQL] data larger than 8k
  In-Reply-To: <13744.56996.353223.158765@siren.bio.indiana.edu>
  References: <13742.11506.902372.667917@siren.bio.indiana.edu> <199807161658.SAA15445@aisa.fi.muni.cz> <13744.56996.353223.158765@siren.bio.indiana.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox