Re: Create Trigger porting problem from Oracle to PostgreSQL7.3.2

Hi,
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 <bedo7@gmx.net>
To: pgsql-sql@postgresql.org
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 
<pgsql-sql-postgresql.org@localhost.postgresql.org>; 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 <pgsql-sql-postgresql.org@localhost.postgresql.org>; 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 
<pgsql-sql@postgresql.org>; 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: pgsql-sql-postgresql.org@localhost.postgresql.org
X-Authenticated: #718964
Message-ID: <3FCE160F.1000004@gmx.net>
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: pgsql-sql-owner+M16194@postgresql.org
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