Re: [BUGS] BUG #5753: Existing Functions No Longer Work

2010-11-13 Thread Tom Lane
vince maxey writes: > I am running my test procs from the pgAdminIII GUI.  Is my syntax wrong to > execute the function?  If I run select test_proc1(3), I do get the correct > result which is a column header (test_proc1 integer) and a value (2).  So why > wouldn't I get a 6-column result set wh

Re: [BUGS] BUG #5753: Existing Functions No Longer Work

2010-11-13 Thread vince maxey
Thanks for your response, Tom. I guess my question would be, what needs to change in my syntax to expect to get one row returned? Here are a couple of examples that do work in my existing application prior to my recent computer switch and re-build (and I have well over 100 of these types of f

Re: [BUGS] BUG #5753: Existing Functions No Longer Work

2010-11-13 Thread Tom Lane
"Vince Maxey" writes: > Recently I upgraded a personal application built a number of years ago, > including java, eclipse, struts and postgresql and now face an issue with > postgresql in that application functions no longer work, specfically as > related to refcursors. The original application w

[BUGS] BUG #5753: Existing Functions No Longer Work

2010-11-13 Thread Vince Maxey
The following bug has been logged online: Bug reference: 5753 Logged by: Vince Maxey Email address: vama...@yahoo.com PostgreSQL version: 9.0 Operating system: Windows Description:Existing Functions No Longer Work Details: Hi, Recently I upgraded a personal applic

[BUGS] WARNING: 01000: could not dump unrecognized node type: 928

2010-11-13 Thread Jon Nelson
I get this whenever debug_print_rewritten = on WARNING: 01000: could not dump unrecognized node type: 928 LOCATION: _outNode, outfuncs.c:2787 right before LOG: 0: rewritten parse tree: PostgreSQL 8.4.5 on Linux x86-64 Does this sound familiar? -- Jon -- Sent via pgsql-bugs mailing l