This function doesn't shown in pgAdmin III, but does in pgAdmin II - Mailing list pgadmin-support

Hello

This is what I get in Version 3:

<SNIP>
-- Function: cobra.code_gebiet(varchar, int4, int4, int4)

-- DROP FUNCTION cobra.code_gebiet(varchar, int4, int4, int4);

CREATE OR REPLACE FUNCTION cobra.code_gebiet(varchar, int4, int4, int4) RETURNS varchar AS
'' LANGUAGE 'plpgsql' VOLATILE;
</SNIP>

in Version 2 I get this (which is correct and also in the PG_DUMP):

<SNIP>
Create Or Replace Function cobra.code_gebiet(varchar,int4,int4,int4)
Returns varchar As '

--
************************************************************************
******
-- Ver    Datum       Autor  Änderung
-- -----  ----------  -----  ------------------------------------
-- 1.0    017.03.20023 df     Erstellt
--
************************************************************************
******
-- Beschreibung:
--
-- Holt den Code aus der Code-Tabelle. Falls die Sprache nicht existiert
ist der
-- Fallback Deutsch. Wenn auch Deutsch nicht existiert --> Fehler
--
************************************************************************
******
DECLARE  gebiet_i    ALIAS FOR $1;  code_i    ALIAS FOR $2;  spr_i    ALIAS FOR $3;  short_i    ALIAS FOR $4;
  bez_        codetext.bez%TYPE;  kbez_    codetext.kbez%TYPE;  --  true_    CONSTANT INTEGER  := 1;  false_
CONSTANTINTEGER  := 0;  errm_    VARCHAR(2000);
 
BEGIN  SELECT    cote.kbez,    cote.bez  INTO        kbez_,        bez_  FROM        codetext_v    cote,       code_v
    code  WHERE    code.gebiet   = UPPER(gebiet_i)  AND        code.code     = code_i  AND        cote.code_seq =
code.code_seq AND        cote.spr_code = spr_i;
 
  IF short_i = true_ THEN     RETURN(kbez_);  ELSE     RETURN(bez_);  END IF;
  IF NOT FOUND THEN  -- If nothing was returned in the last query     SELECT    cote.kbez,    cote.bez     INTO
kbez_,       bez_     FROM    codetext_v    cote,    code_v        code     WHERE    code.gebiet   = UPPER(gebiet_i)
AND    code.code     = code_i     AND    cote.code_seq = code.code_seq     AND    cote.spr_code = 1;        -- Fix
Deutsch
     IF NOT FOUND THEN  -- If nothing was returned in the last query        errm_ := ''code_sprache: Code not found,
GEBIET=''||                 gebiet_||'', CODE=''||code_i;        RETURN(errm_);     ELSE        IF short_i = true_ THEN
  RETURN(kbez_); ELSE    RETURN(bez_); END IF;     END IF;
 
  END IF;

END;
'
Language 'plpgsql';
</SNIP>

Any ideas?

Versions:

PgAdmin III:    1.0.0
PostgreSQL:        7.3.3

Regards

Dieter