Re: [SQL] Wierded error in recursive function; debugging ideas?

2004-08-11 Thread Josh Berkus
Joe, > Are you sure this message isn't coming from some PHP middleware, e.g. > peardb or something. See: > http://us2.php.net/manual/en/function.in-array.php Hm ... possible. Will check with my PHP guy. Would explain why I've not been able to track down the error. -- -Josh Berkus "A d

Re: [SQL] Wierded error in recursive function; debugging ideas?

2004-08-11 Thread Joe Conway
Josh Berkus wrote: [2] Wrong datatype for second argument in call to in_array SQL: SELECT sf_event_decendants(66645,111) Are you sure this message isn't coming from some PHP middleware, e.g. peardb or something. See: http://us2.php.net/manual/en/function.in-array.php Joe ---

Re: [SQL] Wierded error in recursive function; debugging ideas?

2004-08-11 Thread Josh Berkus
Joe, > There is no in_array() function in Postgres that I'm aware of -- you > sure that isn't array_in()? Yep. That's a cut-and-paste of the exact log message. > The rest of that error message doesn't seem > to be there in 7.4 either. Can we see the function? Sure: CREATE OR REPLACE FUNCTIO

Re: [SQL] Wierded error in recursive function; debugging ideas?

2004-08-10 Thread Joe Conway
Josh Berkus wrote: I'm seeing this bizarre, unreproducable error in my logs: [2] Wrong datatype for second argument in call to in_array SQL: SELECT sf_event_decendants(66645,111) I also checked for in_array and it's not a visible built-in function. Is this maybe a PostgreSQL bug? Version is 7

[SQL] Wierded error in recursive function; debugging ideas?

2004-08-10 Thread Josh Berkus
Folks, I'm seeing this bizarre, unreproducable error in my logs: [2] Wrong datatype for second argument in call to in_array   SQL: SELECT sf_event_decendants(66645,111) The problem is that it's proven completely impossible to reproduce this error at test time; it only seems to happen in product