| From: | "Nilesh A(dot) Phadke" <nphadke(at)csgrad(dot)cs(dot)vt(dot)edu> |
|---|---|
| To: | Thomas Egge <teg(at)ratio(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Read values from Trigger out |
| Date: | 2000-02-09 17:28:38 |
| Message-ID: | Pine.OSF.4.21.0002091225270.22846-100000@csgrad.cs.vt.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello Thomas,
I have used the same thing and it does work for me.... I was also getting
similar problems initially....
What does your trigger do? does it insert a tuple back into the table? if
yes then that is your problem ... coz the insert will fire another trigger
and this may continue endlessly....
Nilesh.
On Wed, 9 Feb 2000, Thomas Egge wrote:
> I have created a trigger function.
>
> could somebody tell me how I get the values from the insert in the trigger
> function.
> I tried the function
>
> SPI_getvalue(trigger,tupdesc,attnum)
>
> but after starting the trigger, I become this terminating output:
>
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> We have lost the connection to the backend, so further processing is impossible. Terminating.
>
>
> thank's for your help
> --
> Thomas Egge
>
> ************
>
>
-------------------------------------------------------------------
Your intellect is the best gift given to you by god |
How you use it decides your gift back to him........ |
-------------------------------------------------------------------
Nilesh Phadke | e-mail: nilesh(at)collegemail(dot)com |
Graduate Research Asstt. | Phone : (540) 951 8399 |
Department of Computer Science | Addr : 1011 University City Blvd |
Virginia Tech. | Apt I-7 |
| Blacksburg, VA 24060 |
-------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Juvonen | 2000-02-09 17:49:23 | Help needed with DBI and DBD::Pg |
| Previous Message | Thomas Egge | 2000-02-09 15:36:56 | Read values from Trigger out |