Обсуждение: 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 theinformation contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received thiscommunication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the messageand 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
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.bhattacharyya@cmcltd.com <anindya.bhattacharyya@cmcltd.com> wrote:
http://www.postgresql.org/community/lists/
Andrew
On 4/9/07, anindya.bhattacharyya@cmcltd.com <anindya.bhattacharyya@cmcltd.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.bhattacharyya@cmcltd.com <anindya.bhattacharyya@cmcltd.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 theinformation contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received thiscommunication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the messageand any attachments. Thank you" > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >