X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B7DB49DC894 for ; Sun, 15 Jan 2006 06:12:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57318-06 for ; Sun, 15 Jan 2006 06:12:57 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id BDD6D9DC847 for ; Sun, 15 Jan 2006 06:12:53 -0400 (AST) Received: from red.jesrie.de (red.jesrie.de [62.146.91.106]) by svr4.postgresql.org (Postfix) with ESMTP id 826345AF024 for ; Sun, 15 Jan 2006 10:12:56 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by red.jesrie.de (Postfix) with ESMTP id F30FC2C0054 for ; Sun, 15 Jan 2006 11:15:59 +0100 (CET) Received: from red.jesrie.de ([127.0.0.1]) by localhost (red.jesrie.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25729-10 for ; Sun, 15 Jan 2006 11:15:59 +0100 (CET) Received: from mail.arsoft.homeip.net (i3ED6E1D9.versanet.de [62.214.225.217]) by red.jesrie.de (Postfix) with ESMTP id B57B72C000D for ; Sun, 15 Jan 2006 11:15:59 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mail.arsoft.homeip.net (Postfix) with ESMTP id B37ACA304 for ; Sun, 15 Jan 2006 11:12:45 +0100 (CET) Received: from mail.arsoft.homeip.net ([192.168.1.1]) by localhost (ds [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14894-06 for ; Sun, 15 Jan 2006 11:12:33 +0100 (CET) Received: from [192.168.1.19] (unknown [192.168.1.19]) by mail.arsoft.homeip.net (Postfix) with ESMTP id 94CC9A2F0 for ; Sun, 15 Jan 2006 11:12:33 +0100 (CET) From: Andreas Roth To: pgsql-sql@postgresql.org Subject: Trigger for Large Object Modification Date: Sun, 15 Jan 2006 11:12:32 +0100 User-Agent: KMail/1.9.1 MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200601151112.32669.aroth@arsoft-online.com> X-Virus-Scanned: by amavisd-new at arsoft.homeip.net X-Virus-Scanned: amavisd-new at jesire.de X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.15 required=5 tests=[RCVD_IN_NJABL_PROXY=0.327, RCVD_IN_SORBS_SOCKS=1.823] X-Spam-Score: 2.15 X-Spam-Level: ** X-Archive-Number: 200601/76 X-Sequence-Number: 23865 Hello, I created a table with a OID Column to carry the identifier for a Large Object. Now i want to run a trigger is the data of the large object has changed. To do this I created an ON UPDATE-trigger on the table, but the trigger does get fired if i only change the data of the large object (not its id). Is there any way to get notified if a large object has changed? Thanks in advance, A. Roth