I agree, But I've been doing this by the book, what should I do then? On Mon, 31 Mar 2003, Tom Lane wrote:
> Date: Mon, 31 Mar 2003 13:24:42 -0500 > From: Tom Lane <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: pgsql-hackers list <[EMAIL PROTECTED]> > Subject: Re: [HACKERS] What's wrong > > [EMAIL PROTECTED] writes: > > It worked fine in 7.2 but now IFAICS, it never gives the original result > > and moreover, if I run SELECT sql_crypt('xxx','xxx') several times, it > > gives 3 diferent results and loops other those 3 results. > > I would've expected it to be unreliable under previous versions too. > AFAICS you aren't taking care to ensure that the inputs to crypt() > are null-terminated. > > regards, tom lane > -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly