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

Hi Dieter,

Can you try the latest snapshot from http://snake.pgadmin.org/snapshots/win32 please? It looks OK here using CVS tip.

Regards, Dave.

> -----Original Message-----
> From: Dieter Fischer [mailto:dieter.fischer@grid-it.ch]
> Sent: 03 November 2003 17:34
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] This function doesn't shown in
> pgAdmin III, but does in pgAdmin II
>
> 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_    CONSTANT INTEGER  := 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>