X-Original-To: pgsql-interfaces@postgresql.org Received: from pd5mo2so.prod.shaw.ca (shawidc-mo1.cg.shawcable.net [24.71.223.10]) by postgresql.org (Postfix) with ESMTP id 6977E47592C for ; Fri, 7 Mar 2003 16:25:32 -0500 (EST) Received: from pd2mr2so.prod.shaw.ca (pd2mr2so-ser.prod.shaw.ca [10.0.141.109]) by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002)) with ESMTP id <0HBE000L0E6L5I@l-daemon> for pgsql-interfaces@postgresql.org; Fri, 07 Mar 2003 14:25:33 -0700 (MST) Received: from pn2ml2so.prod.shaw.ca (pn2ml2so-qfe0.prod.shaw.ca [10.0.121.146]) by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002)) with ESMTP id <0HBE00DJTE6L9R@l-daemon> for pgsql-interfaces@postgresql.org; Fri, 07 Mar 2003 14:25:33 -0700 (MST) Received: from power ([24.80.229.122]) by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002)) with ESMTP id <0HBE00KEBE6LO3@l-daemon> for pgsql-interfaces@postgresql.org; Fri, 07 Mar 2003 14:25:33 -0700 (MST) Date: Fri, 07 Mar 2003 13:36:48 -0800 From: Daniel Bruce Lynes Subject: Truncating lobs To: pgsql-interfaces@postgresql.org Message-id: <200303071336.49010.dlynes@shaw.ca> MIME-version: 1.0 X-Mailer: KMail [version 1.4] Content-type: text/plain; charset=gb2312 Content-transfer-encoding: 7BIT X-Archive-Number: 200303/16 X-Sequence-Number: 3765 Are there any methods to truncate a lob, other than by modifying the main PostgreSQL source tree? i.e. is there a fastpath method I can call to truncate a lob? I noticed the JDBC3 driver includes a Lob truncation method, but it is unimplemented. Thanks