Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7ED2EP03184 for ; Tue, 14 Aug 2001 09:02:14 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from server1.workware (workwa.lnk.telstra.net [139.130.59.240]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f785Wx614882 for ; Wed, 8 Aug 2001 01:33:02 -0400 (EDT) (envelope-from heatherm@famoice.com) Received: from localhost (root@localhost) by server1.workware (8.9.3/8.9.3) with ESMTP id PAA03992 for ; Wed, 8 Aug 2001 15:32:52 +1000 From: heatherm@famoice.com X-OpenMail-Hops: 1 Date: Wed, 8 Aug 2001 15:32:52 +1000 Message-Id: Subject: deleting large objects from jdbc TO: pgsql-sql@postgresql.org Encoding: 20 text X-Archive-Number: 200108/181 X-Sequence-Number: 4405 Hi, I've been browsing the newsgroup archives and came across the following: > > > > > Can you see a scenario where a programmer would forget to delete the > > > > > data from pg_largeobject and the database becoming very large filled > > > > > with orphaned large objects? Does this mean that to delete my large object I need to delete the row in my table, and also the row or rows in pg_largeobject. Currently I am only deleting the row in my table. I have just been looking at the pg_largeobject table, it seems to have more rows than I would expect in it. Is the solution to pass these two commands to jdbc? delete from my_table where lob_oid = 1234 delete from pg_largeobject where loid = 1234 Thanks in advance Heather.