Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group