Received: from sh.fishinteractive.com (IDENT:root@[202.101.38.5]) by hub.org (8.10.1/8.10.1) with ESMTP id e8F2sLs76517 for ; Thu, 14 Sep 2000 22:54:22 -0400 (EDT) Received: from danny ([172.18.1.117]) by sh.fishinteractive.com (8.9.3/8.9.3) with SMTP id LAA07067 for ; Fri, 15 Sep 2000 11:09:39 +0800 Message-Id: <200009150309.LAA07067@sh.fishinteractive.com> Date: Fri, 15 Sep 2000 10:57:8 +0800 From: danny To: "pgsql-sql@postgresql.org" Subject: demo of using large objects interface in php X-mailer: FoxMail 3.1 beta [cn] Mime-Version: 1.0 Content-Type: text/plain; charset="GB2312" Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/108 Hi, Finally, I can give the demo of using large objects interface in php. the test table: create table lo_test ( id serial, raster oid, primary key(id) ); file: lo_insert.php \n"; $handle = pg_loopen ($db, $oid, "w"); echo ("handle=$handle
\n"); $fp = fopen ("/etc/rc.d/rc.local", "r"); echo "$fp"; while (!feof($fp)) { pg_lowrite($handle, fread($fp, 4096)); } fclose($fp); pg_loclose($handle); pg_exec($db, "insert into lo_test (raster) values ($oid)"); pg_exec($db, "commit"); pg_close($db); ?> file: lo_read.php \n"; $handle = pg_loopen ($db, $oid, "r"); echo ("$handle\n"); //pg_loreadall($handle); while ($buf=pg_loread($handle, 80)) { echo nl2br($buf); } pg_loclose($handle); pg_exec($db, "commit"); pg_close($db); ?> file: lo_delete.php \n"; pg_lounlink ($oid); pg_exec($db, sprintf('delete from lo_test where id = %s', $record[0])); pg_exec($db, "commit"); pg_close($db); ?> There is a better way to delete the large object associated with the record. create trigger like this: CREATE FUNCTION lo_test_del () RETURNS OPAQUE AS ' BEGIN perform lo_unlink(OLD.raster); RETURN OLD; END; ' LANGUAGE 'plpgsql'; CREATE TRIGGER "tg_lo_test_del" BEFORE DELETE ON "lo_test" FOR EACH ROW EXECUTE PROCEDURE "lo_test_del" (); when you run 'delete from lo_test where id = 1' the large object will be deleted in cascade. regards Danny Chen dannychen@fishinteractive.com