[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Refactored Payment.sql::payment_bulk_post()
- Subject: Re: Refactored Payment.sql::payment_bulk_post()
- From: Chris Travers <..hidden..>
- Date: Mon, 9 Jan 2012 06:56:39 -0800
On Sun, Jan 8, 2012 at 7:17 AM, Erik Huelsmann <..hidden..> wrote:
> Hi Chris,
>> The execute statements are necessary because PLPGSQL caches query
>> plans, meaning that repeat runs of the function will generate errors
>> in the same session unless EXECUTE is used.
>> I will be back in Jakarta tomorrow and will be resuming normal work schedule.
> Great! I had some time to look into it, so I thought I'd do whatever I
> can today -- my normal work schedule after all prevents us to talk a
> lot during the workweek.
> So, if I understand correctly, you're referring to this PostgreSQL
> FAQ: http://wiki.postgresql.org/wiki/FAQ#Why_do_I_get_.22relation_with_OID_.188.8.131.52.23_does_not_exist.22_errors_when_accessing_temporary_tables_in_PL.2FPgSQL_functions.3F
I had missed the fact that this was changed in 8.3 so we may be ok.