Re: Refactored Payment.sql::payment_bulk_post()

["..hidden.." <..hidden..>]

Hi chris,

neither did i. Your answer made me search.

Bye,

erik

Sent from my Nokia phone
-----Original Message-----
From: Chris Travers
Sent:  09/01/2012, 15:56 
To: Development discussion for LedgerSMB
Subject: Re: [Ledger-smb-devel] Refactored Payment.sql::payment_bulk_post()


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_.23.23.23.23.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.

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual 
desktops for less than the cost of PCs and save 60% on VDI infrastructure 
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel