Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 402589FBC47
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  9 Mar 2007 13:26:42 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 82373-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  9 Mar 2007 13:26:29 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172])
	by postgresql.org (Postfix) with ESMTP id 40D0B9FB782
	for <pgsql-sql@postgresql.org>; Fri,  9 Mar 2007 13:26:27 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id k3so1334555ugf
	for <pgsql-sql@postgresql.org>; Fri, 09 Mar 2007 09:26:26 -0800 (PST)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=lL+zsFow6yw9WFgBtf48Y/xdCOQ3nqRBhyzCq8EdPvn/RINuVx7lS0YEVFLBimRZouviGFRbfBNQ6WYWUhrQlFnxr7KJviv5bu6+o2nXN+d4OvGQvNOdCpl0jP8rD0xCjHTDfc4IO6DjU3rnSY6GX49jZ2x8CL/RJWP4v3BADwY=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=GPFS1H76aC7a385wiG4YdXs1qAPq5InsHKeSr52lgWbrIGNAdmqCqw0KuN72WVl/byakvzaHJl2r6oYZTI88/8kk9isYO84ZS132eszUeTQxWecDqVsr0x+0/Kqe8F2rmLBtYrOs7bfgSuUdR2/k8KYd8+zF/VpNw6s8eUtes6k=
Received: by 10.67.117.2 with SMTP id u2mr9982942ugm.1173461186141;
	Fri, 09 Mar 2007 09:26:26 -0800 (PST)
Received: by 10.67.94.13 with HTTP; Fri, 9 Mar 2007 09:26:26 -0800 (PST)
Message-ID: <55c095e90703090926h66697deem7c0bfeccdb55474c@mail.gmail.com>
Date: Fri, 9 Mar 2007 14:26:26 -0300
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: "Chad Wagner" <chad.wagner@gmail.com>
Subject: Re: SHA-1 vs MD5
Cc: PostgreSQL <pgsql-sql@postgresql.org>
In-Reply-To: <81961ff50703090514k562d1218rd44df84a13d69507@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_166_21494527.1173461186048"
References: <55c095e90703071204t5aebb921s9d5f1067d3c2f035@mail.gmail.com>
	<81961ff50703071344i28d9ea6cr4902fed404b38602@mail.gmail.com>
	<55c095e90703080339y67152f49ud82741fd21ac6370@mail.gmail.com>
	<81961ff50703080652o41274e2djc5b789fb4da9bd27@mail.gmail.com>
	<55c095e90703090434ob874f2q4ff3cfd0d91c88f3@mail.gmail.com>
	<81961ff50703090514k562d1218rd44df84a13d69507@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/119
X-Sequence-Number: 27757

------=_Part_166_21494527.1173461186048
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

You are correct. My pg (8.1.3)

Now what I do to remove it ?

Just delete the functions ?

Ezequias

2007/3/9, Chad Wagner <chad.wagner@gmail.com>:
>
> On 3/9/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> >
> > Thank you so much for your information. I installed the pgCrypto. Now I
> > have more than 40 functions (i believe all are from pgcrypto) but when I try
> > to run your query:
> >
> > select encode(digest('blahblah', 'sha256'), 'hex');
> >
> > I got the error:
> >
> > ERROR: Cannot use "sha256": No such hash algorithm
> > SQL state: 22023
> >
>
>
> It may not be available in your version of the database/pgcrypto module,
> my test was performed on 8.2.3.
>



-- 
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/

------=_Part_166_21494527.1173461186048
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

You are correct. My pg (8.1.3)<br><br>Now what I do to remove it ?<br><br>Just delete the functions ?<br><br>Ezequias<br><br><div><span class="gmail_quote">2007/3/9, Chad Wagner &lt;<a href="mailto:chad.wagner@gmail.com">chad.wagner@gmail.com
</a>&gt;:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><span class="q">On 3/9/07, <b class="gmail_sendername">Ezequias Rodrigues da Rocha
</b> &lt;<a href="mailto:ezequias.rocha@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">ezequias.rocha@gmail.com</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

Thank you so much for your information. I installed the pgCrypto. Now I have more than 40 functions (i believe all are from pgcrypto) but when I try to run your query:<span><br><br><span style="font-style: italic; font-weight: bold;">


select encode(digest(&#39;blahblah&#39;, &#39;sha256&#39;), &#39;hex&#39;);</span><br><br></span>I got the error:<br><br><span style="font-weight: bold;">ERROR: Cannot use &quot;sha256&quot;: No such hash algorithm</span>

<br style="font-weight: bold;">
<span style="font-weight: bold;">SQL state: 22023</span><br style="font-weight: bold;"></blockquote></div><br><br></span>It may not be available in your version of the database/pgcrypto module, my test was performed on 8.2.3
.<br>
</blockquote></div><br><br clear="all"><br>-- <br>Ezequias Rodrigues da Rocha<br><a href="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a><br>use Mozilla Firefox:<a href="http://br.mozdev.org/firefox/">
http://br.mozdev.org/firefox/</a>

------=_Part_166_21494527.1173461186048--