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 e58NTcT07372 for ; Thu, 8 Jun 2000 19:29:38 -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 e58NTUb02892 for ; Fri, 9 Jun 2000 09:29:30 +1000 (EST) Message-Id: <200006082329.e58NTUb02892@piglet.dstc.edu.au> X-Mailer: exmh version 2.1.0 09/18/1999 To: pgsql-sql@postgresql.org Subject: Is it possible to "truncate" a LOB? From: Stephen Crawley Date: Fri, 09 Jun 2000 09:29:30 +1000 X-Archive-Number: 200006/99 [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