Not signed in (Sign In)

Vanilla 1.1.8 is a product of Lussumo. More Information: Documentation, Community Support.

IP.Board PostgreSQL modification: [Sticky] plpgsql Language Support Required

Bottom of Page

1 to 1 of 1

  1.  
    •  
      CommentAuthorakinwale
    • CommentTimeNov 25th 2008
     

    Our modification requires the PostgreSQL database to have plpgsql language support enabled. Usually, this is enabled by default, but I have come across some installations that don't have this option enabled.

    There are two ways to do this, but you have to have superuser access to the database that you want to modify.

    1. Running it as a query in PostgreSQL
    CREATE LANGUAGE plpgsql

    2. From the command line (Unix-based environment)
    createlang -U postgres plpgsql <database>

    Where postgres is assumed to be a superuser account, and <database> is the name of the database where you want to have the plpgsql language enabled.

    For more information, you can have a look at http://www.postgresql.org/docs/8.1/interactive/sql-createlanguage.html

1 to 1 of 1

  1.