[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: Sun, 8 Jan 2012 06:48:57 -0800
Hi;
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.
Best Wishes,
Chris Travers