Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-23 Thread Horst Herb
> Btw, the concept of checksumming rows is kinda new to me. > I needed this to store passwords on a table, so sorry if I > cant be more help. But I am a litte bit curious, why is it > needed? Simple checksumming (crc32/md5) does not help malicious > changing of data, only hardware failures, but

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-21 Thread Marko Kreen
On Sat, Oct 21, 2000 at 11:27:54PM +1000, Horst Herb wrote: > > > > http://www.l-t.ee/marko/pgsql/pgcrypto-0.1.tar.gz(11k) > > First of all, thankd for tis contribution. I had impemented a > similar thing for my own purposes. A problem I still have is using > the digest for "checksumming" r

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-21 Thread Horst Herb
> > > http://www.l-t.ee/marko/pgsql/pgcrypto-0.1.tar.gz(11k) First of all, thankd for tis contribution. I had impemented a similar thing for my own purposes. A problem I still have is using the digest for "checksumming" rows in my tables - which is a 'MUST' for medico-legal reasons in my

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-19 Thread Marko Kreen
On Thu, Oct 19, 2000 at 08:27:00PM +0200, Karel Zak wrote: > On Thu, 19 Oct 2000, Marko Kreen wrote: > > On Thu, Oct 19, 2000 at 01:33:35PM -0400, Tom Lane wrote: > > > Marko Kreen <[EMAIL PROTECTED]> writes: > > > > If there is interest I can package it as a contrib or even > > > > mainstream dif

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-19 Thread Marko Kreen
On Thu, Oct 19, 2000 at 08:55:55PM +0200, Peter Eisentraut wrote: > Marko Kreen writes: > > Here is a implementation of crypto hashes for PostgreSQL. > > > It is packaged at the moment as stand-alone package, because > > I am trying to write general autoconf macros for use with outside > > packag

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-19 Thread Peter Eisentraut
Marko Kreen writes: > Here is a implementation of crypto hashes for PostgreSQL. > It is packaged at the moment as stand-alone package, because > I am trying to write general autoconf macros for use with outside > packages. At the moment any package author must generate those > himself. Also th

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-19 Thread Karel Zak
On Thu, 19 Oct 2000, Marko Kreen wrote: > On Thu, Oct 19, 2000 at 01:33:35PM -0400, Tom Lane wrote: > > Marko Kreen <[EMAIL PROTECTED]> writes: > > > If there is interest I can package it as a contrib or even > > > mainstream diff against CVS ??? > > > > Sure, I think people would be interested

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-19 Thread Marko Kreen
On Thu, Oct 19, 2000 at 01:33:35PM -0400, Tom Lane wrote: > Marko Kreen <[EMAIL PROTECTED]> writes: > > If there is interest I can package it as a contrib or even > > mainstream diff against CVS ??? > > Sure, I think people would be interested. It might be best to make it > contrib for now, unti

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-19 Thread Marko Kreen
On Thu, Oct 19, 2000 at 07:31:28PM +0200, Karel Zak wrote: > On Thu, 19 Oct 2000, Marko Kreen wrote: > > > > http://www.l-t.ee/marko/pgsql/pgcrypto-0.1.tar.gz(11k) At the last second I thougt that I should generate the 'configure' so its 20k actually... > > > If it's really allows use a

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-19 Thread Tom Lane
Marko Kreen <[EMAIL PROTECTED]> writes: > If there is interest I can package it as a contrib or even > mainstream diff against CVS ??? Sure, I think people would be interested. It might be best to make it contrib for now, until you are sure you have dealt with portability and installation issues

Re: [HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-19 Thread Karel Zak
On Thu, 19 Oct 2000, Marko Kreen wrote: > > > http://www.l-t.ee/marko/pgsql/pgcrypto-0.1.tar.gz(11k) > > Here is a implementation of crypto hashes for PostgreSQL. > It can be linked with various libraries: > > standalone: > MD5, SHA1 > > (the code is from KAME proje

[HACKERS] [ANNC][RFC] crypto hashes for PostgreSQL 7.0, 7.1

2000-10-19 Thread Marko Kreen
http://www.l-t.ee/marko/pgsql/pgcrypto-0.1.tar.gz(11k) Here is a implementation of crypto hashes for PostgreSQL. It exports 2 functions to SQL level: digest(data::text, hash_name::text) which returns hexadecimal coded hash over data by specified algorithm. eg >