Received: from rm-rstar.sfu.ca (root@rm-rstar.sfu.ca [142.58.120.21]) by hub.org (8.9.2/8.9.1) with ESMTP id RAA35120 for ; Wed, 17 Mar 1999 17:52:39 -0500 (EST) (envelope-from gburnham@sfu.ca) Received: from apemantus (apemantus.educ.sfu.ca [142.58.6.61]) by rm-rstar.sfu.ca (8.9.1/8.9.1/SFU-5.0H) with SMTP id OAA20653 for ; Wed, 17 Mar 1999 14:52:37 -0800 (PST) Message-ID: <008301be70c8$dbb69a20$3d063a8e@educ.sfu.ca> From: "Gregory W Burnham" To: Subject: lo_open() - truncate a large object? Date: Wed, 17 Mar 1999 14:52:38 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.0810.800 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800 RedHat 5.1 Kernel 2.0.35 (i686) Postgresql 6.3.2 I'd like to be able to open a large object and have it truncated, something like this: int fd = lo_open(conn, oid, INV_READ | INV_WRITE | O_TRUNC); But of course that doesn't work. Is there a way to do this with postgresql? Gregory W Burnham Software Engineer Excite Labs Simon Fraser University Vancouver, BC V5A 1S6 604 291 3615 ph 604 291 5679 fx