Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    156
    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:
    151
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice