pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Is it possible to "truncate" a LOB?
2+ messages / 1 participants
[nested] [flat]

* Is it possible to "truncate" a LOB?
@ 2000-06-06 00:35  Stephen Crawley <crawley@dstc.edu.au>
  0 siblings, 0 replies; 2+ messages in thread

From: Stephen Crawley @ 2000-06-06 00:35 UTC (permalink / raw)
  To: pgsql-interfaces@postgresql.org; pgsql-sql


Suppose that I have created a LOB, written a bunch of data to it, and 
committed.

Is it now possible to rewrite the LOB to contain a lesser amount of data?
In other words can I do the equivalent of UNIX open(..., O_WRONLY | O_TRUNC) 
or ftruncate(...) on a LOB?

Or am I forced to delete the existing LOB and create a new one if I want
to shrink the size of the stored data?

-- Steve









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

* Is it possible to "truncate" a LOB?
@ 2000-06-08 23:29  Stephen Crawley <crawley@dstc.edu.au>
  0 siblings, 0 replies; 2+ messages in thread

From: Stephen Crawley @ 2000-06-08 23:29 UTC (permalink / raw)
  To: pgsql-sql

[I asked this question on the "interfaces" list, but nobody answered ...]

Suppose that I have created a LOB, written a bunch of data to it, and 
committed.

Is it now possible to rewrite the LOB to contain a lesser amount of data?
In other words can I do the equivalent of UNIX open(..., O_WRONLY | O_TRUNC) 
or ftruncate(...) on a LOB?

Or am I forced to delete the existing LOB and create a new one if I want
to shrink the size of the stored data?

-- Steve











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


end of thread, other threads:[~2000-06-08 23:29 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-06 00:35 Is it possible to "truncate" a LOB? Stephen Crawley <crawley@dstc.edu.au>
2000-06-08 23:29 Is it possible to "truncate" a LOB? Stephen Crawley <crawley@dstc.edu.au>

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