The Community Forums

Interact with an entire community of cPanel & WHM users.
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

postgresql question

Discussion in 'General Discussion' started by I Love Jesus, Dec 6, 2004.

  1. I Love Jesus

    I Love Jesus AKA chadi

    Joined:
    Dec 6, 2004
    Messages:
    62
    Likes Received:
    0
    Trophy Points:
    6
    I'm not too savvy about postgresql but I got this as a customer request...

    Could you please add PL/PGSQL language support for my Postgres database called "username_dxall"? These 2 commands should do the trick as long as your shared object is in the same directory as mine:

    CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler
    AS '/usr/lib/pgsql/plpgsql.so', 'plpgsql_call_handler'
    LANGUAGE c;

    CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;


    What is this doing? I already have Apache compiled with PostgreSQL anyway. Is this something different?

    Thanks :)
     
  2. hendricknet

    hendricknet Member

    Joined:
    Apr 8, 2005
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
Loading...

Share This Page