Обсуждение: No way to have error message on pgadmin III pg 8.0

Поиск
Список
Период
Сортировка

No way to have error message on pgadmin III pg 8.0

От
"Laurent Birckel"
Дата:

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"

somebody can help me ?

Thanks a lot

Laurent Birckel

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

От
"Dave Page"
Дата:
 

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.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.

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

От
"Laurent Birckel"
Дата:
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@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.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.

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

От
"Laurent Birckel"
Дата:
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@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.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@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.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.

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

От
"Dave Page"
Дата:
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.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.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@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.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@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.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.

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

От
"Laurent Birckel"
Дата:
I try to resend this mail (perhaps the attachements are not accepted)
-----Message d'origine-----
De : Laurent Birckel [mailto:laurent.birckel@uni-medecine.fr]
Envoyé : lundi 21 mars 2005 18:19
À : Dave Page; pgadmin-support@postgresql.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@vale-housing.co.uk]
Envoyé : lundi 21 mars 2005 15:54
À : Laurent Birckel; pgadmin-support@postgresql.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.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.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@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.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@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.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.

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

От
"Dave Page"
Дата:
 

From: Laurent Birckel [mailto:laurent.birckel@uni-medecine.fr]
Sent: 21 March 2005 17:19
To: Dave Page; pgadmin-support@postgresql.org
Subject: 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)
in the attachement (.txt) , I forgot the ';' after the END IF
 
if I forget ANYTHING (a ';', a ')' or anything else) in the "messages",
        => I get absolutely NOTHING. (see the jpeg attached)
 
 
 
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 !
 
Don't be sad!!
 
When I try to execute the script you attached, I get the following error:

ERROR:  syntax error at or near "_idPJ" at character 817
 
Which is clearly caused by the missing semi-colon on the preceding 'end if'. pgAdmin also puts a line marker on the offending line.
 
I don't recall anything changing recently, but can I send you an up to date snapshot to try?
 
Regards, Dave.

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

От
"Laurent Birckel"
Дата:
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)
 
the other guys of my company have the same trouble,
 
sorry
 
Laurent
-----Message d'origine-----
De : Dave Page [mailto:dpage@vale-housing.co.uk]
Envoyé : mardi 22 mars 2005 14:45
À : 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:laurent.birckel@uni-medecine.fr]
Sent: 21 March 2005 17:19
To: Dave Page; pgadmin-support@postgresql.org
Subject: 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)
in the attachement (.txt) , I forgot the ';' after the END IF
 
if I forget ANYTHING (a ';', a ')' or anything else) in the "messages",
        => I get absolutely NOTHING. (see the jpeg attached)
 
 
 
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 !
 
Don't be sad!!
 
When I try to execute the script you attached, I get the following error:

ERROR:  syntax error at or near "_idPJ" at character 817
 
Which is clearly caused by the missing semi-colon on the preceding 'end if'. pgAdmin also puts a line marker on the offending line.
 
I don't recall anything changing recently, but can I send you an up to date snapshot to try?
 
Regards, Dave.

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

От
"Dave Page"
Дата:
 

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

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

От
"Laurent Birckel"
Дата:
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:dpage@vale-housing.co.uk]
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: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

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

От
"Dave Page"
Дата:
[CC'd to the pginstaller list]
 
Hmm, that's a PostgreSQL/pgInstaller problem then. Did you manually change the locale settings, or let the installer do it for you?
 
Regards, Dave.

From: Laurent Birckel [mailto:laurent.birckel@uni-medecine.fr]
Sent: 22 March 2005 16:33
To: Dave Page; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

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:dpage@vale-housing.co.uk]
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: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

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

От
"Laurent Birckel"
Дата:
for the 2 tests above, I just let the installer work. Once I installed the national langage support (on the installer), the second time i didn't.
and if I install the national langage support => Bang ! I don't have any messages.
 
ragards
 
Laurent
-----Message d'origine-----
De : Dave Page [mailto:dpage@vale-housing.co.uk]
Envoyé : mercredi 23 mars 2005 09:19
À : Laurent Birckel; pgadmin-support@postgresql.org
Cc : pginstaller-devel@pgfoundry.org
Objet : RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

[CC'd to the pginstaller list]
 
Hmm, that's a PostgreSQL/pgInstaller problem then. Did you manually change the locale settings, or let the installer do it for you?
 
Regards, Dave.

From: Laurent Birckel [mailto:laurent.birckel@uni-medecine.fr]
Sent: 22 March 2005 16:33
To: Dave Page; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

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:dpage@vale-housing.co.uk]
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: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

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

От
"Laurent Birckel"
Дата:
just a modification: not "NATIONAL language", but "NATURAL language" (on the setup, it causs the empty error messages)
 
Laurent
-----Message d'origine-----
De : Dave Page [mailto:dpage@vale-housing.co.uk]
Envoyé : mercredi 23 mars 2005 09:19
À : Laurent Birckel; pgadmin-support@postgresql.org
Cc : pginstaller-devel@pgfoundry.org
Objet : RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

[CC'd to the pginstaller list]
 
Hmm, that's a PostgreSQL/pgInstaller problem then. Did you manually change the locale settings, or let the installer do it for you?
 
Regards, Dave.

From: Laurent Birckel [mailto:laurent.birckel@uni-medecine.fr]
Sent: 22 March 2005 16:33
To: Dave Page; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

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:dpage@vale-housing.co.uk]
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: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