Tom, or anyone else working with this dB, can you respond to my question:
How should the syntax for a function be formulated to return a refcursor
containing one or more records?
I have many years SQL development experience and work with Oracle in my current
position. I'm not a novice progr
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
hello
2010/11/16 vince maxey :
> Tom, or anyone else working with this dB, can you respond to my question:
>
> How should the syntax for a function be formulated to return a refcursor
> containing one or more records?
>
http://www.network-theory.co.uk/docs/postgresql/vol2/ReturningCursors.html
I
I have a process which runs in parallel creating tables which, as the
/final/ step in the import, gets SQL much like the following applied:
ALTER TABLE foo INHERIT bar;
Periodically, I get this error: tuple concurrently updated
Of course, I googled for the error message and see a bunch of issue
2010/11/16 vince maxey :
> 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 food
> and there will be no repercussions, other than you will receive an email
> indica
/*
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 c
/*
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 stoc
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
