. Thanks.
dp_blag=# CREATE OR REPLACE FUNCTION sha512(text) RETURNS text AS
'dp_sha512.so','dp_sha512' LANGUAGE C STRICT;
CREATE FUNCTION
dp_blag=# SELECT sha512('jf');
ERROR: invalid memory alloc request size 4294967293
PG_FUNCTION_INFO_V1(dp_sha512);
Da
lt;[EMAIL PROTECTED]>
> To: jf <[EMAIL PROTECTED]>
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] UDFs
>
> On Mon, Aug 13, 2007 at 03:17:36PM +, jf wrote:
> > Hi.
> >
> > Trying to implement some simple digest routines via UDFs and for wh
2007, hubert depesz lubaczewski wrote:
> Date: Mon, 13 Aug 2007 11:29:58 +0200
> From: hubert depesz lubaczewski <[EMAIL PROTECTED]>
> To: jf <[EMAIL PROTECTED]>
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] UDFs
>
> On Mon, Aug 13, 2007 at 03:17:36
g out,
even if now that all is said and done it would've been easier to use
pgcrypto.
> best regards,
>
> depesz
cheers,
jf
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
> share of *installed* system. if you compiled with --prefix=/usr/local,
> then it would be /usr/local/share/postgresql/...
Ah you have to forgive me, I'm in the states and its quite late ;]
> of course - you dont need all (on the other hand - i strongly suggest
> that you get some familiarity wi
ly it's in: /share/postgresql/contrib/pgcrypto.sql
> in the database you want to use pgcrypto functions, you simply run this
> sql (as superuser), and that's all.
theory# pwd
/home/jf/postgresql-8.2.4
theory# cd share
bash: cd: share: No such file or directory
theory# pwd
/home/jf
