From: Clint Stotesbery <cstotes@hotmail.com>
To: bedo7@gmx.net
Cc: pgsql-sql@postgresql.org
Subject: Re: Create Trigger porting problem from Oracle to PostgreSQL7.3.2
Date: Wed, 03 Dec 2003 17:26:49 +0000
Message-ID: <BAY9-F8n3mmYMhm2cll0000c32a@hotmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cstotes@hotmail.com, bedo7@gmx.net
Subject: Re: Create Trigger porting problem from Oracle to PostgreSQL7.3.2
In-Reply-To: <BAY9-F8n3mmYMhm2cll0000c32a@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox