pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeddata 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