I
think I found id !
i
uninstalled twice more and reinstall postgresSQL xith the
installer
if I
check the "national langage support" to be installed on the Hard
disk
==> I have No error
messages
if I
don't check this
==> I have some error
messages
THEN
.... I think there is a trouble with this "national langage
support"
anyway, thanks for your help !
Laurent
-----Message d'origine-----
De : Dave Page [mailto:[EMAIL PROTECTED]
Envoyé : mardi 22 mars 2005 16:14
À : Laurent Birckel; pgadmin-support@postgresql.org
Objet : RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0
From: Laurent Birckel [mailto:[EMAIL PROTECTED]
Sent: 22 March 2005 14:01
To: Dave Page; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0I 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