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

Re: crash in plancache with subtransactions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jim Nasby <Jim(at)Nasby(dot)net>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: crash in plancache with subtransactions
Date: 2010-11-01 16:25:08
Message-ID: 21519.1288628708@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Jim Nasby <Jim(at)Nasby(dot)net> writes:
> (looking at original case)... the original bug wasn't actually
> recursive.

No, there are two different cases being dealt with here.  If the first
call of an expression results in an error, and then we come back and try
to re-use the expression state tree, we can have trouble because the
state tree contains partially-updated internal state for the called
function.  This doesn't require any recursion but it leads to pretty
much the same problems as the recursive case.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Jeff DavisDate: 2010-11-01 18:19:14
Subject: Re: revision of todo: NULL for ROW variables
Previous:From: Andrew DunstanDate: 2010-11-01 16:02:20
Subject: Re: why does plperl cache functions using just a bool for is_trigger

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