Re: howto use pgencrypto ?

I was just having the exact same problem, thanks for your post Joe. :)
----- Original Message -----
From: "Joe Conway" <mail@joeconway.com>
To: "David H" <godave621@yahoo.com>
Cc: <pgsql-novice@postgresql.org>
Sent: Friday, December 05, 2003 2:23 PM
Subject: Re: [NOVICE] howto use pgencrypto ?


> David H wrote:
>
> > select encrypt
> > ('srcip'::bytea,'pass'::bytea,'bf'::text)::bytea as
> > "test" from tbltcplog limit 3;
> >
> > I got:
> >
> > ERROR:  Function encrypt(bytea, bytea, text) does not
> > exist
> >         Unable to identify a function that satisfies
> > the given argument types
> >         You may need to add explicit typecasts
>
> The pgcrypto README doesn't seem to mention it, but in general, after
> building any of the contrib libraries, you need to "load" them into any
> databases in which you want to use their functions. Something like:
>
> psql mydatabase < pgcrypto.sql
>
> However, If you are using the regression database after running make
> installcheck, the functions should be there. I get this:
>
> regression=# \df encrypt
>                       List of functions
>   Result data type | Schema |  Name   | Argument data types
> ------------------+--------+---------+---------------------
>   bytea            | public | encrypt | bytea, bytea, text
> (1 row)
>
> So I'd conclude you are not using the regression database and need to
> follow the first suggestion ;-)
>
> HTH,
>
> Joe
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>