thank you for your attention
kris, i'll keep the patch but i won't patch my pgsql because i cannot
tell my "customers" (it's a OS program; if it will run ok, maybe my
company will switch from mssql to pgsql) to patch their pgsql installation.
i look forward for the final release of pgsql 8 and o
Kris Jurka <[EMAIL PROTECTED]> writes:
> On Tue, 19 Oct 2004, Alvaro Herrera wrote:
>> Huh, shouldn't the user rather do
>> SELECT func_returning_void();
> The problem is that the function may actually be a SRF so the JDBC driver
> transforms to the "SELECT * FROM" form.
It's not really any weird
On Tue, 19 Oct 2004, Alvaro Herrera wrote:
> Huh, shouldn't the user rather do
>
> SELECT func_returning_void();
The problem is that the function may actually be a SRF so the JDBC driver
transforms to the "SELECT * FROM" form. The JDBC driver doesn't want to
get into the business of trying to
On Tue, Oct 19, 2004 at 06:23:07PM -0500, Kris Jurka wrote:
>
> On Tue, 19 Oct 2004, federico wrote:
>
> > i saw in bug 1201 that some got my problem
> > [ you can't do "SELECT * FROM func_returning_void();" ]
>
> This patch seems to fix it, although I have no idea what the actual
> implication
On Tue, 19 Oct 2004, federico wrote:
> i saw in bug 1201 that some got my problem
> [ you can't do "SELECT * FROM func_returning_void();" ]
This patch seems to fix it, although I have no idea what the actual
implications are, I just changed any place that produced an error.
Kris Jurka
Index:
i saw in bug 1201 that some got my problem
i detail it
i have a function that returns a void
CREATE OR REPLACE FUNCTION myFunction(int2, int2)
RETURNS void AS
$BODY$
UPDATE table
SET field1 = $1
WHERE field2 = $2;
$BODY$
LANGUAGE 'sql' VOLATILE;
when i execute it with a callablestatement
Call
On Tue, 27 Jul 2004, PostgreSQL Bugs List wrote:
> Bug reference: 1201
> Logged by: Jonathan Scott
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 7.4
> Description:void functions called through jdbc driver return error
>
> At work here, we are considering up
The following bug has been logged online:
Bug reference: 1201
Logged by: Jonathan Scott
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: Linux
Description:void functions called through jdbc driver return error
Details:
Hello all,
At w
