[ADMIN] Using PL/pgSQL with statically built PostgreSQL binaries

2004-07-13 Thread Bill Chandler
Hi, I built my Solaris PostgreSQL 7.4.2 installation using: configure --disable-shared My reason was so that clients that install it would have everything there in one binary tar file and would not have to install any gcc lib patches, etc. Anyway, everything seemed to work great until I wante

[ADMIN] Using PL/pgSQL

2004-01-26 Thread Arun Gananathan
Hi, I want to try some functions using pl/pgsql in the unix. i have tried the following 'createlang plpgsql yourdb' function and that is giving the following error message, which is ERROR:  Only users with Postgres superuser privilege are permitted to create a function in the 'C' language.