Re: No way to have error message on pgadmin III pg 8.0
От | Dave Page |
---|---|
Тема | Re: No way to have error message on pgadmin III pg 8.0 |
Дата | |
Msg-id | E7F85A1B5FF8D44C8A1AF6885BC9A0E472BCC1@ratbert.vale-housing.co.uk обсуждение исходный текст |
Ответ на | No way to have error message on pgadmin III pg 8.0 ("Laurent Birckel" <laurent.birckel@uni-medecine.fr>) |
Список | pgadmin-support |
From: Laurent Birckel [mailto:laurent.birckel@uni-medecine.fr]
Sent: 21 March 2005 08:26
To: Dave Page; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0Sorry , I searched , but I didn't found any way to display error messagesIf anybody have an idea, It should be nicethanks for helpLaurent.-----Message d'origine-----
De : pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org]De la part de Laurent Birckel
Envoyé : vendredi 18 mars 2005 18:25
À : Dave Page; pgadmin-support@postgresql.org
Objet : Re: [pgadmin-support] No way to have error message on pgadmin III pg 8.0Thanks 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@vale-housing.co.uk]
Envoyé : vendredi 18 mars 2005 18:02
À : Laurent Birckel; pgadmin-support@postgresql.org
Objet : RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Laurent Birckel
Sent: 18 March 2005 16:51
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] No way to have error message on pgadmin III pg 8.0where 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.
В списке pgadmin-support по дате отправления: