Thread: bug when creating/dropping function with a user defiend domain (adds size)
bug when creating/dropping function with a user defiend domain (adds size)
From
"Eric P. Melbardis"
Date:
<div class="Section1"><p class="MsoNormal"><span style="color:#1F497D">Retry: having issue with e-mail…</span><p class="MsoNormal"><spanstyle="color:#1F497D"> </span><p class="MsoNormal"> <p class="MsoNormal">hi when i execute the followingscript using pgadmin query tool:<p class="MsoNormal"> <p class="MsoNormal">windows xp, sp2<p class="MsoNormal">pgadmin1.8.2 as installed whith postgres binary 8.3.1<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <pclass="MsoNormal">--------------------------------<p class="MsoNormal"> <p class="MsoNormal">CREATEDOMAIN "dt_0" AS varchar(32)<p class="MsoNormal"> NULL;<p class="MsoNormal"> <p class="MsoNormal">CREATEDOMAIN "dt_1" AS varchar<p class="MsoNormal"> NULL;<p class="MsoNormal"> <p class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal">CREATE FUNCTION "x1" (IN name dt_0, IN description dt_1)<p class="MsoNormal">RETURNSinteger <p class="MsoNormal">AS $$<p class="MsoNormal">SELECT 0;<p class="MsoNormal">$$<p class="MsoNormal">LANGUAGESQL<p class="MsoNormal">IMMUTABLE<p class="MsoNormal">RETURNS NULL ON NULL INPUT;<p class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal">---------------------------<p class="MsoNormal"> <p class="MsoNormal"> <pclass="MsoNormal">when i look at the function definition using pgadmin it looks like this:<p class="MsoNormal"> <pclass="MsoNormal">-- Function: x1(dt_0(36), dt_1)<p class="MsoNormal"> <p class="MsoNormal">-- DROPFUNCTION x1(dt_0(36), dt_1);<p class="MsoNormal"> <p class="MsoNormal">CREATE OR REPLACE FUNCTION x1("name" dt_0(36),description dt_1)<p class="MsoNormal"> RETURNS integer AS<p class="MsoNormal">$BODY$<p class="MsoNormal">SELECT0;<p class="MsoNormal">$BODY$<p class="MsoNormal"> LANGUAGE 'sql' IMMUTABLE STRICT<p class="MsoNormal"> COST 100;<p class="MsoNormal">ALTER FUNCTION x1(dt_0(36), dt_1) OWNER TO postgres;<p class="MsoNormal"> <pclass="MsoNormal">--------------------------<p class="MsoNormal"> <p class="MsoNormal">if i try to deleteit: i get:<p class="MsoNormal"> <p class="MsoNormal">an error has occured: tyep modifier is not allowed for type "dt_0"<pclass="MsoNormal"> <p class="MsoNormal">why is the (36) there????<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal">regards<pclass="MsoNormal"> <p class="MsoNormal"> </div>