On Tue, Nov 16, 2010 at 5:13 PM, Kris Jurka 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 was doing
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 self-co
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 stoc
/*
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
ime or make you do work I should be able to
> do for myself. I'm out of ideas, Tom.
>
> Sincerely,
>
> Vince Maxey
>
>
>
> - Original Message
> From: Tom Lane
> To: vince maxey
> Cc: pgsql-bugs@postgresql.org
> Sent: Tue, November 16, 2010 11:31:2
should be able to
> do for myself. I'm out of ideas, Tom.
>
> Sincerely,
>
> Vince Maxey
>
>
>
> - Original Message
> From: Tom Lane
> To: vince maxey
> Cc: pgsql-bugs@postgresql.org
> Sent: Tue, November 16, 2010 11:31:28 AM
> Subject: Re:
others can use to create their own functions.
>
> thank you for your assistance.
>
>
> - Original Message
> From: vince maxey vama...@yahoo.com
> To: Tom Lane
> Cc: Me Yahoo ; pgsql-bugs@postgresql.org
> Sent: Sat, November 13, 2010 3:44:03 PM
> Subject: Re
vince maxey 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 working within m
which others can use to create their own functions.
thank you for your assistance.
- Original Message
From: vince maxey vama...@yahoo.com
To: Tom Lane
Cc: Me Yahoo ; pgsql-bugs@postgresql.org
Sent: Sat, November 13, 2010 3:44:03 PM
Subject: Re: [BUGS] BUG #5753: Existing Functions No Lon
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
(conn, proc);
}
return locations;
}
If I am not including something specific required to actually display a result
set, can you enlighten me? How would you write a function to return a row from
the test data I provided? I'm stumped.
Sincerely,
Vince Maxey
- Original Mess
"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
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
13 matches
Mail list logo