pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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