Re: BUG #2260: PGCrypto Memory Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Daniel Blaisdell" <lunk(dot)djedi(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2260: PGCrypto Memory Problem
Date: 2006-02-15 18:21:48
Message-ID: 14902.1140027708@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Daniel Blaisdell" <lunk(dot)djedi(at)gmail(dot)com> writes:
> Table Setup:
> employeeid integer
> salt text
> md5password text

> Problem Query:
> select * from table where md5password = crypt('password',salt)

I tried this with dummy data and couldn't see any memory leak, using
Fedora Core 4 and CVS-tip postgres (but there've been no recent changes
in pgcrypto that would affect this).

I suspect you may have a memory leak in Gentoo's implementation of
crypt(). Another possible theory is that it's data-dependent, in which
case you need to show some sample data that triggers it.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-02-15 18:29:20 Re: BUG #2259: never ending select from selects
Previous Message Michael Fuhr 2006-02-15 18:20:43 Re: BUG #2260: PGCrypto Memory Problem