| From: | Terry Lee Tucker <terry(at)esc1(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Trigger Question |
| Date: | 2005-01-05 20:25:08 |
| Message-ID: | 200501051525.09000.terry@esc1.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
When I assign a value to a certain column in a table A, I want to be able to
assign a value in table A to table B and then to assign a value in table B to
table C. I was wanting to do this from the trigger level in an AFTER UPDATE
trigger to ensure it gets done. I would like to be able to pass the serial
keys of the associated records in table B and C to the AFTER UPDATE trigger
so I could find the records in tables B and C and perform the updates.
Does that make sense?
Thanks for the reply...
On Wednesday 05 January 2005 03:18 pm, Michael Fuhr saith:
> On Wed, Jan 05, 2005 at 02:56:27PM -0500, Terry Lee Tucker wrote:
> > Is there any way to pass dynamic data into a trigger function? I think
> > the answer is no, but just in case...
>
> What do you mean by "dynamic data"? What problem are you trying
> to solve?
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
--
Work: 1-336-372-6812
Cell: 1-336-363-4719
email: terry(at)esc1(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2005-01-05 20:34:01 | Re: PostgreSQL users on webhosting |
| Previous Message | Michael Fuhr | 2005-01-05 20:18:29 | Re: Trigger Question |