I ran into the same thing last week. There is no way to specify that functionality in the trigger creation for Postgresql. You will have to code the trigger to detect when the specific field is updated. Tom Lane had suggested something for me last week. Check out the archive for the mailing list at
http://archives.postgresql.org/pgsql-sql/2003-11/index.php
and scroll down to November 26. Perhaps Tom will have more to say on this, he's pretty good at this stuff.
On another note have you converted any instead of triggers from Oracle to Postgres? I'm not sure how to do that yet, maybe using rules but I'll save that for another message to the mailing list.
-Clint
----Original Message Follows----
From: Doris Bernloehr <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [SQL] Create Trigger porting problem from Oracle to PostgreSQL7.3.2
Date: Wed, 03 Dec 2003 17:57:51 +0100
MIME-Version: 1.0
Received: from mc10-f9.hotmail.com ([65.54.166.145]) by mc10-s5.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Wed, 3 Dec 2003 09:12:31 -0800
Received: from hosting.commandprompt.com ([207.173.200.192]) by mc10-f9.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Wed, 3 Dec 2003 09:11:53 -0800
Received: from postgresql.org (svr1.postgresql.org [200.46.204.71])by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id hB3GwtS23721;Wed, 3 Dec 2003 08:59:18 -0800
Received: from localhost (neptune.hub.org [200.46.204.2])by svr1.postgresql.org (Postfix) with ESMTP id 98A82D1B4AEfor <[EMAIL PROTECTED]>; Wed, 3 Dec 2003 16:58:39 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 58440-05 for <[EMAIL PROTECTED]>; Wed, 3 Dec 2003 12:58:08 -0400 (AST)
Received: from mail.gmx.net (imap.gmx.net [213.165.64.20])by svr1.postgresql.org (Postfix) with SMTP id 58C07D1D388for <[EMAIL PROTECTED]>; Wed, 3 Dec 2003 12:58:07 -0400 (AST)
Received: (qmail 23665 invoked by uid 65534); 3 Dec 2003 16:57:51 -0000
Received: from dsl-213-023-040-229.arcor-ip.net (EHLO gmx.net) (213.23.40.229) by mail.gmx.net (mp001) with SMTP; 03 Dec 2003 17:57:51 +0100
X-Message-Info: U2wzkPk8/jYj5Bpg8rsbCR+dCQ716btYhkbL2fD/ZgI=
X-Original-To: [EMAIL PROTECTED]
X-Authenticated: #718964
Message-ID: <[EMAIL PROTECTED]>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624
X-Accept-Language: en-us, en
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Mailing-List: pgsql-sql
Precedence: bulk
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 03 Dec 2003 17:11:53.0858 (UTC) FILETIME=[8C803E20:01C3B9C0]
Hello
I've got a problem in porting a trigger from Oracle into PostgreSQL. In Oracle you can choose between UPDATE and UPDATE OF COLUMN ...
Is there a way to have the same functionality in PostgreSQL?
Hope anyone can give me an advice.
Doris
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
_________________________________________________________________
Winterize your home with tips from MSN House & Home. http://special.msn.com/home/warmhome.armx
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
