From: | "Laurent Birckel" <laurent(dot)birckel(at)uni-medecine(dot)fr> |
---|---|
To: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: No way to have error message on pgadmin III pg 8.0 |
Date: | 2005-03-21 08:26:09 |
Message-ID: | IIEKLKLBOEKJJJCGJHPDAEPBIFAA.laurent.birckel@uni-medecine.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
Envoye : vendredi 18 mars 2005 18:25
A : 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]
Envoye : vendredi 18 mars 2005 18:02
A : 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Asger Petersen | 2005-03-21 12:12:08 | Re: Extremely slow queries in pgAdminIII |
Previous Message | Daniel Seichter | 2005-03-21 07:47:33 | printing table-structure |