Re: No way to have error message on pgadmin III pg 8.0 - Mailing list pgadmin-support

From Dave Page
Subject Re: No way to have error message on pgadmin III pg 8.0
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E472BD03@ratbert.vale-housing.co.uk
Whole thread Raw
In response to No way to have error message on pgadmin III pg 8.0  ("Laurent Birckel" <laurent.birckel@uni-medecine.fr>)
Responses Re: No way to have error message on pgadmin III pg 8.0
List pgadmin-support
 


From: Laurent Birckel [mailto:laurent.birckel@uni-medecine.fr]
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.0

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

pgadmin-support by date:

Previous
From: Alan Corey
Date:
Subject: Minor annoyance with Windows Help in pgAdmin III
Next
From: "Laurent Birckel"
Date:
Subject: Re: No way to have error message on pgadmin III pg 8.0