BUG #2139: Problem when calling functions without any argument

On 1/3/06, Jacques Gollion <jgollion@sambatechnologies.com> wrote:

The following bug has been logged online:

Bug reference: 2139
Logged by: Jacques Gollion
Email address: jgollion@sambatechnologies.com
PostgreSQL version: 8.1.1
Operating system: Windows 2000
Description: Problem when calling functions without any argument
Details:

have have written some functions without any argument. When my powerbuilder
V9 application calls these functions, the behaviour is different :

*Using ODBC driver, it works well
*Using JDBC driver (I tried several versions), I get the error message
"ERROR : Syntax error at or near $1. If I add a unused argument to the
function; it works.
If I call in JDBC the same function for Oracle or Sybase, it works.
If I call other PostGreSQL functions with arguments, it works.

Where am I wrong ?

Thanks in advance for your help.

and... where is the function? how is defined? how do you use it?

code, please wiyhout that you can't expect any help...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

hello Jaime,

Sorry. I forgot to provide you with the information. Please find the function and
the trace of jdbc calls in the enclosed file.

Thank you in advance for your help.

Jacques

Jaime Casanova a �crit :

On 1/3/06, Jacques Gollion <jgollion@sambatechnologies.com> wrote:

The following bug has been logged online:

Bug reference: 2139
Logged by: Jacques Gollion
Email address: jgollion@sambatechnologies.com
PostgreSQL version: 8.1.1
Operating system: Windows 2000
Description: Problem when calling functions without any argument
Details:

have have written some functions without any argument. When my powerbuilder
V9 application calls these functions, the behaviour is different :

*Using ODBC driver, it works well
*Using JDBC driver (I tried several versions), I get the error message
"ERROR : Syntax error at or near $1. If I add a unused argument to the
function; it works.
If I call in JDBC the same function for Oracle or Sybase, it works.
If I call other PostGreSQL functions with arguments, it works.

Where am I wrong ?

Thanks in advance for your help.

and... where is the function? how is defined? how do you use it?

code, please wiyhout that you can't expect any help...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

--
________________________________________________________________________
Jacques GOLLION mailto:jgollion@sambatechnologies.com
SAMBA Technologies http://www.sambatechnologies.com
53 chemin du Vieux Chene Phone : +33 (0) 4 76 04 00 59
38240 MEYLAN FRANCE Fax : +33 (0) 4 76 04 15 98
________________________________________________________________________

---------- Forwarded message ----------
From: Jacques Gollion <jgollion@sambatechnologies.com>
Date: Jan 9, 2006 7:01 AM
Subject: Re: [BUGS] BUG #2139: Problem when calling functions without
any argument
To: Jaime Casanova <systemguards@gmail.com>
Cc: pgsql-bugs@postgresql.org

hello Jaime,

Sorry. I forgot to provide you with the information. Please find the
function and
the trace of jdbc calls in the enclosed file.

Thank you in advance for your help.

Jacques

Jaime Casanova a écrit :

On 1/3/06, Jacques Gollion <jgollion@sambatechnologies.com> wrote:

The following bug has been logged online:

Bug reference: 2139
Logged by: Jacques Gollion
Email address: jgollion@sambatechnologies.com
PostgreSQL version: 8.1.1
Operating system: Windows 2000
Description: Problem when calling functions without any argument
Details:

have have written some functions without any argument. When my powerbuilder
V9 application calls these functions, the behaviour is different :

*Using ODBC driver, it works well
*Using JDBC driver (I tried several versions), I get the error message
"ERROR : Syntax error at or near $1. If I add a unused argument to the
function; it works.
If I call in JDBC the same function for Oracle or Sybase, it works.
If I call other PostGreSQL functions with arguments, it works.

Where am I wrong ?

Thanks in advance for your help.

and... where is the function? how is defined? how do you use it?

code, please wiyhout that you can't expect any help...

well. this looks like an specific jdbc issue so i will redirect you to
that list... maybe a little info about the table and the sequence and
maybe the actual code where this error is happening can be of hlp...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)