Greetings all, I *think* there¹s a way to accomplish what I want, but it is eluding me at this time. Any help or pointers will be greatly appreciated. What I am trying to accomplish is that when a member deactivates their account through the UI, my trigger will call a function that deletes or archives their data. The issue being that we don¹t want the UI to have to wait for this process because of the huge amount of data and tables that the queries will have to go through, so we are avoiding doing it programatically through the UI and I want it to happen in the background. The problem is this (and I may just not be thinking clearly): Everything is tied back to the member¹s ID which is the constant throughout the tables that I will need to manipulate. My trigger will call the (to be written) function that will do all the heavy lifting when the active_status changes from Œa¹ to Œx¹, but I somehow need to get the ID of that member and pass it on to the function so it can then do all that it needs to. For simplicity, the member table is just a few columns (id, active_status, name). How would I grab the ID from that table the moment the trigger fires to be able to pass it to my function? I hope that¹s clear. Thanking you in advance for any help. Aaron The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error you should delete it from your system immediately and advise the sender. dunnhumby may monitor and record all emails. The views expressed in this email are those of the sender and not those of dunnhumby. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
