Re: Problem with restoring a 7.1 dump

From: "Magnus Naeslund(f)" <mag(at)fbab(dot)net>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>, "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Problem with restoring a 7.1 dump
Date: 2002-05-01 12:23:49
Message-ID: 020c01c1f10b$0c7ce310$020a0a0a@mnd
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> wrote:
[snap]
> How do I get this to work?
>
> Chris

I think i did this:

CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS
'/usr/local/pgsql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER
"plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';

This might be in the docs also.
Try it :)

Regards,
Magnus

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2002-05-01 14:19:58 Re: Failed compile on Sun
Previous Message Justin Clift 2002-05-01 11:16:31 Re: Failed compile on Sun