Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group