Re: No way to have error message on pgadmin III pg 8.0

["Laurent Birckel" <laurent(dot)birckel(at)uni-medecine(dot)fr>]

I try to resend this mail (perhaps the attachements are not accepted)

-----Message d'origine-----
De : Laurent Birckel [mailto:laurent(dot)birckel(at)uni-medecine(dot)fr]
Envoyé : lundi 21 mars 2005 18:19
À : Dave Page; pgadmin-support(at)postgresql(dot)org
Objet : RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

I write a function (create function) on pgadmin

 

in the text of the function (ie in attachement)

 

/*

 Création d'une PJ:
 select fct_addPJ(1,'aa','bb',123,'cc','dd','ee','ff',0)  
*/

CREATE OR REPLACE FUNCTION fct_addPJ(

 

_idDOC int4,
_titrePJ varchar(250),
_clientFile varchar(255),
_sizePJ int4,
_localName varchar(255),
_localPath varchar(255),
_fileType varchar(100),
_fileSubType varchar(100),
_isDocMetaData int4

)
  RETURNS int4 AS

 

$$
DECLARE
 _idPJ int4;
 
BEGIN
 _idPJ:=0;
 if iddoc <> 0 then
 _idPJ:=fct_getID('PJ');
 if _idPJ <> 0 then
 

 

 insert into PJ
 (
  idPJ,
  idDOC,
  titrePJ,
  clientFile,
  sizePJ,
  localName,
  localPath ,
  fileType ,
  fileSubType ,
  isDocMetaData
 )
 values
 (
  _idPJ,
  _idDOC,
  _titrePJ,
  _clientFile,
  _sizePJ,
  _localName,
  _localPath ,
  _fileType ,
  _fileSubType ,
  _isDocMetaData
 );
 end if ; 
 RETURN _idPJ;  
END;
$$

 

LANGUAGE plpgsql VOLATILE;

  

 

in the attachement (.txt) , I forgot the [LB] first  END IF

 

        => I get absolutely NOTHING. ([LB] the "messages" zone is totaly empty )

 

 

 

then I can't work. I'm on pg 8.01 on windows. we are 3 developers and every body tried something. all with the same result.

 

I'm realy sad !

 

 

Laurent

-----Message d'origine-----
De : Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
Envoyé : lundi 21 mars 2005 15:54
À : Laurent Birckel; pgadmin-support(at)postgresql(dot)org
Objet : RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

Hi,

 

I can't think of any way to make this happen, unless I'm misunderstanding what you are doing. Can you supply step by step instructions to reproduce what you are (ok, aren't!) seeing?

 

Regards, Dave.

---

From: Laurent Birckel [mailto:laurent(dot)birckel(at)uni-medecine(dot)fr]
Sent: 21 March 2005 08:26
To: Dave Page; pgadmin-support(at)postgresql(dot)org
Subject: RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

Sorry , I searched , but I didn't found any way to display error messages

 

If anybody have an idea, It should be nice

 

thanks for help

 

Laurent.

-----Message d'origine-----
De : pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org]De la part de Laurent Birckel
Envoyé : vendredi 18 mars 2005 18:25
À : Dave Page; pgadmin-support(at)postgresql(dot)org
Objet : Re: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

Thanks for your answer.

 

    a validator seems to be set (plpgsql_validator)

    and the validator function exists

        (

CREATE OR REPLACE FUNCTION plpgsql_validator( oid) RETURNS void AS
'$libdir/plpgsql', 'plpgsql_validator'
LANGUAGE 'c' VOLATILE;

        )

 

    I also tried to call my function (sometimes, when the function is syntaxcicaly correct but wrong on another way) from another window.

    But unfortunately i get the same kind of result : no messages. the only way to debug is to add some "return 1 ... return 2 ... to know approximatively where i'ts wrong.

 

    not easy !

 

thanks again, I search..

 

Laurent

-----Message d'origine-----
De : Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
Envoyé : vendredi 18 mars 2005 18:02
À : Laurent Birckel; pgadmin-support(at)postgresql(dot)org
Objet : RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

 

---

From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Laurent Birckel
Sent: 18 March 2005 16:51
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

where working on pgadminIII to writing a function (on windows, postgre 8.0)

if I fortget a ";" or a ")" (for all other errors toot,

I get absolutely nothing when I run the crate or alter function (F5)

I just know that there is an error because I don't have the message "query exucuted ...", but th'ats all

I think I tried everything , but no way to have the error messages like "syntax error at line N"

Unfortunately PostgreSQL doesn't validate most functions when they are created. pl/pgsql does have a basic validator, but it is possible it is not enabled, check it's properties in pgAdmin and ensure a validator is listed. Either way, it is far from perfect, and the best option I find is to have a test query or queries setup in another window ready to run as soon as you've updated the function. That will show you where any errors are found.

Regards, Dave.