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 Best Wishes, Chris Travers ------------------------------------------------------------------------------ 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
