pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
data larger than 8k
4+ messages / 3 participants
[nested] [flat]

* data larger than 8k
@ 1998-07-16 16:40  Danny Rice <dwrice@indiana.edu>
  0 siblings, 1 reply; 4+ messages in thread

From: Danny Rice @ 1998-07-16 16:40 UTC (permalink / raw)
  To: pgsql-sql


If a table element can only handle up to 8k of data what do you do if
you need to insert larger data?

-- 
Danny Rice



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* RE: [SQL] data larger than 8k
@ 1998-07-16 16:58  Rostislav Matl <xmatl@informatics.muni.cz>
  parent: Danny Rice <dwrice@indiana.edu>
  0 siblings, 1 reply; 4+ messages in thread

From: Rostislav Matl @ 1998-07-16 16:58 UTC (permalink / raw)
  To: 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?
> 
> -- 
> Danny Rice

Use large_objects - it's in man pages.

+-----------------------------------------------------------------------------+
|  ROSTISLAV MATL, student of Masaryk University - Faculty of Informatics     |
|  e-mail: xmatl@fi.muni.cz      WWW: http://www.fi.muni.cz/~xmatl/index.html | 
+-----------------------------------------------------------------------------+



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* RE: [SQL] data larger than 8k
@ 1998-07-18 17:43  Danny Rice <dwrice@indiana.edu>
  parent: Rostislav Matl <xmatl@informatics.muni.cz>
  0 siblings, 1 reply; 4+ messages in thread

From: Danny Rice @ 1998-07-18 17:43 UTC (permalink / raw)
  To: Rostislav Matl <xmatl@informatics.muni.cz>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* RE: [SQL] data larger than 8k
@ 1998-07-19 09:40  Peter T Mount <peter@retep.org.uk>
  parent: Danny Rice <dwrice@indiana.edu>
  0 siblings, 0 replies; 4+ messages in thread

From: Peter T Mount @ 1998-07-19 09:40 UTC (permalink / raw)
  To: Danny Rice <dwrice@indiana.edu>; +Cc: Rostislav Matl <xmatl@informatics.muni.cz>; 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@retep.org.uk or petermount@earthling.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@maidstone.gov.uk




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~1998-07-19 09:40 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-07-16 16:40 data larger than 8k Danny Rice <dwrice@indiana.edu>
1998-07-16 16:58 ` Rostislav Matl <xmatl@informatics.muni.cz>
1998-07-18 17:43   ` Danny Rice <dwrice@indiana.edu>
1998-07-19 09:40     ` Peter T Mount <peter@retep.org.uk>

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