Skip site navigation (1) Skip section navigation (2)

Re: Triggers

From: "Usama Munir" <munir(dot)usama(at)gmail(dot)com>
To: "anindya(dot)bhattacharyya(at)cmcltd(dot)com" <anindya(dot)bhattacharyya(at)cmcltd(dot)com>
Cc: "pgsql-jobs(at)postgresql(dot)org" <pgsql-jobs(at)postgresql(dot)org>
Subject: Re: Triggers
Date: 2007-04-17 10:28:50
Message-ID: ff0e67090704170328u568f9654j3b56a1d461c871a2@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jobs
I don't think pgsql-jobs is the forum to ask this question

On 4/9/07, anindya(dot)bhattacharyya(at)cmcltd(dot)com
<anindya(dot)bhattacharyya(at)cmcltd(dot)com> wrote:
>
> I have postgres sql  7.4
> I have a table employee having two fields employee_number varchar(10) ,
> salary(10,2);[primary key employee_number)
>
> I want to track any change   due  update on any row on this table on this
> table.
>
> For this purpose  I have created a table call emplyee_audit having the
> same structure as employee but no primary key
>
> For this purpose I have tried to use trigger with before update option.
> But as could find that Post gres does not support the :old or :new clause.
> So I have not able track changes in emplyee_audit.
>
> Kindly suggest how to accomplish the above task
>
> Regards
>
> Anindya Bhattacharyya
> Manager SI
>
>
>
> DISCLAIMER
>
> "The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you"
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

In response to

  • Triggers at 2007-04-09 09:25:26 from anindya.bhattacharyya

pgsql-jobs by date

Next:From: Cott LangDate: 2007-04-18 22:29:43
Subject: Red Hat / PostgreSQL System Administrator / DBA
Previous:From: Andrew HammondDate: 2007-04-16 19:19:03
Subject: Re: Triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group