Re: Triggers cause backend crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andras Belokosztolszki" <beland1(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Triggers cause backend crash
Date: 2001-10-30 20:50:39
Message-ID: 2455.1004475039@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Andras Belokosztolszki" <beland1(at)hotmail(dot)com> writes:
> <DIV>&nbsp;
> <P class=MsoPlainText><SPAN lang=EN-US style="mso-fareast-font-family: 'MS Mincho'">Hi, I have a problem (I wrote about it before, but here is a complete example). When I have two triggers with parameters the backend crashes after a certain sequence of invocations. Attached are two very simple triggers in C (they might contain some unnecessary lines, they are a stripped version of an application I'm working on), how to compile, how to bootstrap, ... how to crash the backend<BR></SPAN></P>
> <P class=MsoPlainText><SPAN lang=EN-US style="mso-fareast-font-family: 'MS Mincho'">Postgresql info:</SPAN></P><SPAN lang=EN-US style="mso-fareast-font-family: 'MS Mincho'"><FONT size=2>
> <P>PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.95.3</P></FONT></SPAN>
> <P class=MsoPlainText><SPAN lang=EN-US style="mso-fareast-font-family: 'MS Mincho'">A sample makefile (extract from mine)</SPAN></P>
> <P class=MsoPlainText><SPAN lang=EN-US style="mso-fareast-font-family: 'MS Mincho'">&nbsp;</P>
> [etc]

Please don't use HTML for email.

I think your problem is that you've omitted the
PG_FUNCTION_INFO_V1() macro call that's needed to mark these functions
as version-1 calling convention.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-10-31 04:59:17 Bug #506: serializable transaction does may commit in jdbc
Previous Message Tom Lane 2001-10-30 20:45:32 Re: Bug #504: multiple cursors cause transaction problems