From: | "Admin Gaston" <admin(at)intergamesclub(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Postgresql 7.3.2-3 and 7.3.3-4 freeze |
Date: | 2003-07-17 16:36:45 |
Message-ID: | 000d01c34c81$9c9d42f0$152550c8@gaston |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi, first of all i don't speak english very good. I make a function in pl/pgsql, that cause a denial of service. The function has a simple select. If anyone can help with this.
create table "Users" (
"Usu_ID" int, "Usu_Nick" varchar(32), "Usu_Apellido" varchar(50), "Usu_Nombre" varchar(50),
"Usu_Password" varchar(32), "Usu_Email" varchar(64), "Pai_ID" varchar(2), "Usu_FechaNac" date,
"Sex_ID" smallint, "Usu_TipoDoc" varchar(20), "Usu_NumDoc" varchar(20), "Usu_Direccion" varchar(50),
"Usu_CodPostal" varchar(16), "Usu_Ciudad" varchar(35), "Usu_Estado" varchar(35), "Ocu_ID" smallint,
"Ind_ID" smallint, "Usu_FechaInscrip" timestamp with time zone, "Usu_Codigo" varchar(8),
"Usu_Observ" varchar(100), "Usu_Jue_ID" smallint, "Usu_Newsletter" varchar(1), "Usu_Activo" varchar(1),
"Usu_GMT2" varchar(3), "Fmt_ID" smallint, "Usu_Ocu_Other" varchar(50), "Usu_Ind_Other" varchar(50),
"Idi_ID" smallint);
CREATE FUNCTION alta_usuario(varchar, varchar, varchar, varchar, varchar, varchar, smallint, smallint, date, smallint, varchar, varchar, smallint, varchar, varchar, varchar, varchar, varchar, smallint, varchar, smallint, varchar) RETURNS int4 AS '
DECLARE
xUsu_Nick ALIAS FOR $1;
xUsu_Apellido ALIAS FOR $2;
xUsu_Nombre ALIAS FOR $3;
xUsu_Password ALIAS FOR $4;
xUsu_Email ALIAS FOR $5;
xPai_ID ALIAS FOR $6;
xFmt_ID ALIAS FOR $7;
xIdi_ID ALIAS FOR $8;
xUsu_FechaNac ALIAS FOR $9;
xSex_ID ALIAS FOR $10;
xUsu_Codigo ALIAS FOR $11;
xUsu_Newsletter ALIAS FOR $12;
xUsu_Jue_ID ALIAS FOR $13;
xUsu_GMT ALIAS FOR $14;
xUsu_Direccion ALIAS FOR $15;
xUsu_CodPostal ALIAS FOR $16;
xUsu_Ciudad ALIAS FOR $17;
xUsu_Estado ALIAS FOR $18;
xOcu_ID ALIAS FOR $19;
xUsu_Ocu_Other ALIAS FOR $20;
xInd_ID ALIAS FOR $21;
xUsu_Ind_Other ALIAS FOR $22;
Comprueba int4;
BEGIN
IF xUsu_Nick IS NULL THEN
RETURN 0;
END IF;
Comprueba = (SELECT "Usu_ID" FROM "Users" WHERE LOWER("Usu_Nick") = LOWER(xUsu_Nick) );
IF Comprueba IS NOT NULL THEN
RETURN 0;
END IF;
RETURN 1;
END;' LANGUAGE 'plpgsql';
select alta_usuario('cerito','a','a','a','a(at)a(dot)com','AR',1,1,'1981-07-24',1,'a','a',1,'-3','a','a','a','a', 3, '', 4, '');
Regard,
Tavella Gaston.
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Hall | 2003-07-17 17:12:35 | Re: Postgresql 7.3.2-3 and 7.3.3-4 freeze |
Previous Message | Thomas Behr | 2003-07-17 15:06:08 | Small problem in contrib/dbase/dbf2pg.c |