Received: from piglet.dstc.edu.au (piglet.dstc.edu.au [130.102.176.1]) by hub.org (8.10.1/8.10.1) with ESMTP id e560ZqW46445; Mon, 5 Jun 2000 20:35:52 -0400 (EDT) Received: from dstc.edu.au (soluble.dstc.edu.au [130.102.176.43]) by piglet.dstc.edu.au (8.10.1/8.10.1) with ESMTP id e560Zn504797; Tue, 6 Jun 2000 10:35:49 +1000 (EST) Message-Id: <200006060035.e560Zn504797@piglet.dstc.edu.au> X-Mailer: exmh version 2.1.0 09/18/1999 To: pgsql-interfaces@postgresql.org, pgsql-sql@postgresql.org Subject: Is it possible to "truncate" a LOB? Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Tue, 06 Jun 2000 10:35:48 +1000 From: Stephen Crawley X-Archive-Number: 200006/33 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