Re: PLPGSQL Installation - Mailing list pgsql-novice

From Josh Berkus
Subject Re: PLPGSQL Installation
Date
Msg-id [email protected]
Whole thread Raw
In response to PLPGSQL Installation  (Honza Rudovsky <[email protected]>)
List pgsql-novice
Jan,

You need to do this as well:

CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
    '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C';

See
http://www.postgresql.org/idocs/index.php?xplang.html#XPLANG-INSTALL
For more details.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      [email protected]
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: PLPGSQL Installation
Next
From: "Josh Berkus"
Date:
Subject: Re: configuration problems