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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Tue, 17 Apr 2007 15:28:50 +0500
  • Message-id: <ff0e67090704170328u568f9654j3b56a1d461c871a2@mail.gmail.com> <text/plain>

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



  • References:

Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group