On Tue, Nov 16, 2010 at 5:13 PM, Kris Jurka bo...@ejurka.com wrote:
On Tue, 16 Nov 2010, Korry Douglas wrote:
Vince - is there any chance that you were using a non-standard PostgreSQL
distribution or driver before? Like something from EnterpriseDB? It may be
that a third-party JDBC driver
#5753: Existing Functions No Longer Work
Vince Maxey vama...@yahoo.com 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
vince maxey vama...@yahoo.com writes:
My functions all worked prior to switching to 9.0 and I can excute functions
from the pgAdminIII UI which return an individual result, such as an integer,
but cannot test/troubleshoot those which use refcursors in the same manner;
and
they are not
To: Tom Lane t...@sss.pgh.pa.us
Cc: Me Yahoo vama...@yahoo.com; pgsql-bugs@postgresql.org
Sent: Sat, November 13, 2010 3:44:03 PM
Subject: Re: [BUGS] BUG #5753: Existing Functions No Longer Work
Thanks for your response, Tom.
I guess my question would be, what needs to change in my syntax
...@yahoo.com
Cc: pgsql-bugs@postgresql.org
Sent: Tue, November 16, 2010 11:31:28 AM
Subject: Re: [BUGS] BUG #5753: Existing Functions No Longer Work
vince maxey vama...@yahoo.com writes:
My functions all worked prior to switching to 9.0 and I can excute functions
from the pgAdminIII UI which return
1:14:14 PM
Subject: Re: [BUGS] BUG #5753: Existing Functions No Longer Work
2010/11/16 vince maxey vama...@yahoo.com:
Here is my website: www.emenusonline.net It appears that the pg version my
web
host company uses is 8.1.3
Right now this site is in beta mode, so you can register and order
/*
you cannot to fetch data from function that returns a refcursor.
refcursor is varchar - name of some object (cursor). when you open
cursor, then you can specify a name (it's refcursor), but when you
fetch data, you must to use a direct sql identifier of cursor - not a
reference.
simply, you
On Tue, 16 Nov 2010, Korry Douglas wrote:
Vince - is there any chance that you were using a non-standard PostgreSQL
distribution or driver before? Like something from EnterpriseDB? It may be
that a third-party JDBC driver was doing some behind-the-curtains work on
your behalf.
The
On 17/11/10 05:42, vince maxey wrote:
You are speaking to me entirely in abstract, where I have provided you with
several concrete examples of functions that work when called from the java
application.
I've only been following this thread broadly, but I haven't seen a
complete and
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
Vince Maxey vama...@yahoo.com 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
a row from
the test data I provided? I'm stumped.
Sincerely,
Vince Maxey
- Original Message
From: Tom Lane t...@sss.pgh.pa.us
To: Vince Maxey vama...@yahoo.com
Cc: pgsql-bugs@postgresql.org
Sent: Sat, November 13, 2010 1:03:46 PM
Subject: Re: [BUGS] BUG #5753: Existing Functions
vince maxey vama...@yahoo.com 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
13 matches
Mail list logo