Re: Triggers

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"

Since you're asking on the -jobs mailing list, perhaps you want to hire a
PostgreSQL consultant? If that's the case, you could post an RFP or job
description to this list. Alternatively, you can find consulting firms from
all over the world at the following page.

http://www.postgresql.org/support/professional_support

If on the other hand you actually want your question answered, perhaps you
should ask it in a forum such as pgsql-general, pgsql-sql or even
pgsql-novice? You can see descriptions of the various mailing lists here:

http://www.postgresql.org/community/lists/

Andrew

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
>

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
>