Re: Problem with restoring a 7.1 dump - Mailing list pgsql-hackers

From Magnus Naeslund(f)
Subject Re: Problem with restoring a 7.1 dump
Date
Msg-id 020c01c1f10b$0c7ce310$020a0a0a@mnd
Whole thread Raw
In response to Problem with restoring a 7.1 dump  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.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



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Problem with restoring a 7.1 dump
Next
From: "Rod Taylor"
Date:
Subject: Analyze on large changes...