RE: [SQL] data larger than 8k

From: Danny Rice <dwrice(at)indiana(dot)edu>
To: Rostislav Matl <xmatl(at)informatics(dot)muni(dot)cz>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: RE: [SQL] data larger than 8k
Date: 1998-07-18 17:43:00
Message-ID: 13744.56996.353223.158765@siren.bio.indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
> 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Konstantinos Vassiliadis 1998-07-18 18:05:09 Inserting values into set attributes
Previous Message Konstantinos Vassiliadis 1998-07-18 16:33:11 Modelling relationships (fwd)