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:[EMAIL PROTECTED] > Sent: 03 November 2003 17:34 > To: [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
