Postgresql 7.3.2-3 and 7.3.3-4 freeze
От | Admin Gaston |
---|---|
Тема | Postgresql 7.3.2-3 and 7.3.3-4 freeze |
Дата | |
Msg-id | 000d01c34c81$9c9d42f0$152550c8@gaston обсуждение исходный текст |
Ответы |
Re: Postgresql 7.3.2-3 and 7.3.3-4 freeze
|
Список | pgsql-bugs |
Hi, first of all i don't speak english very good. I make a function in pl/p= gsql, 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_Nomb= re" 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), "Us= u_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, v= archar, smallint, smallint, date, smallint, varchar, varchar, smallint, var= char, varchar, varchar, varchar, varchar, smallint, varchar, smallint, varc= har) 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 =3D (SELECT "Usu_ID" FROM "Users" WHERE LOWER("Usu_Nick") =3D LOW= ER(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@a.com','AR',1,1,'1981-07-24',1,= 'a','a',1,'-3','a','a','a','a', 3, '', 4, ''); Regard, Tavella Gaston.=
В списке pgsql-bugs по дате отправления: