On 06/20/2011 04:08 PM, Chris Travers wrote: > On Mon, Jun 20, 2011 at 12:59 PM, John Locke <[email protected]> wrote: >> Ok. Ran across a different issue related to the new tax account stuff, >> that might be related. >> >> LedgerSMB::DBObject provides an object wrapper around stored functions >> -- when called with a method that is not populated in the class >> definition, it looks for a stored function of that name, and then parses >> the parameters that function takes and populates a query with those >> properties on the object itself. >> >> The problem is when there are multiple functions with the same name, but >> a different parameter signature. I had two different account__save >> functions in my database, and the DBObject was picking the old one with >> fewer parameters. After deleting that, I got the new updated function. >> And of course, since the signature had changed, CREATE OR UPDATE >> FUNCTION didn't delete the old one. > > Right. I corrected Erik's script after the fact. Drop the function > with fewer arguments. > > If you want to check for other functions which might be accidently > overloaded, cd to the sql/modules/test directory (you have to be > working from that directory), open psql, and run: > \i System.sql
Is this safe to do on a production database? ------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
