I am very happy for you, but i rest Sad for me ! I beleive you, but my problem is not solved.
I have absolutely NOTHING on my "messages" zone.
when i get some messages (not on this case, the offending line is NEVER the good one.
If you have it and not me, I think there is something wrong on my config, but I can't find it.
is it possible due to the encoding (I use LATIN9) ? we tried firts UNICODE, and changed to Latin9 (no change about the error messages)
I get the same error message using LATIN9.
OK, can you try creating the function using psql? You should see something like:
template1=# CREATE DATABASE foo ENCODING 'latin9';
CREATE DATABASE
template1=# \connect foo
You are now connected to database "foo".
foo=# CREATE OR REPLACE FUNCTION fct_addPJ(
foo(#
foo(# _idDOC int4,
foo(# _titrePJ varchar(250),
foo(# _clientFile varchar(255),
foo(# _sizePJ int4,
foo(# _localName varchar(255),
foo(# _localPath varchar(255),
foo(# _fileType varchar(100),
foo(# _fileSubType varchar(100),
foo(# _isDocMetaData int4
foo(#
foo(#
foo(# )
foo-# RETURNS int4 AS
foo-#
foo-# $$
foo$# DECLARE
foo$# _idPJ int4;
foo$#
foo$# BEGIN
foo$#
foo$# _idPJ:=fct_getID('PJ');
foo$# if _idPJ <> 0 then
foo$#
foo$#
foo$# insert into PJ
foo$# (
foo$# idPJ,
foo$# idDOC,
foo$# titrePJ,
foo$# clientFile,
foo$# sizePJ,
foo$# localName,
foo$# localPath ,
foo$# fileType ,
foo$# fileSubType ,
foo$# isDocMetaData
foo$# )
foo$# values
foo$# (
foo$# _idPJ,
foo$# _idDOC,
foo$# _titrePJ,
foo$# _clientFile,
foo$# _sizePJ,
foo$# _localName,
foo$# _localPath ,
foo$# _fileType ,
foo$# _fileSubType ,
foo$# _isDocMetaData
foo$# );
foo$# end if
foo$# RETURN _idPJ;
foo$# END;
foo$# $$
foo-#
foo-# LANGUAGE plpgsql VOLATILE;
ERROR: syntax error at or near "_idPJ" at character 652
LINE 50: RETURN _idPJ;
^
foo=#
Regards, Dave
