"Daniel Blaisdell" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org