Re: problem with FOUND and EXECUTE in pl/pgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with FOUND and EXECUTE in pl/pgsql
Date: 2009-06-03 21:17:41
Message-ID: 25137.1244063861@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> seems I don't understand how FOUND variable in pl/pgsql function defined,
> when I use EXECUTE of PERFORM. There is no problem when I use plain SQL.

EXECUTE doesn't affect FOUND, even if the statement-to-be-executed would
have. There's been some discussion about changing that, but no
movement.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2009-06-03 21:18:10 Re: High I/O writes activity on disks causing images on browser to lag and not load
Previous Message Terry Lee Tucker 2009-06-03 21:16:31 Re: warm standby with WAL shipping