Re: Adding a Language and Creating a Function

Thanks to all. I got it figured out. Redhat had an older version of
PostgreSQL on my computer and I installed a newer version. I had referenced
the Redhat version in my createlang command. When I changed the path to my
new file it worked.

Sorry for the trouble

Dean

-----Original Message-----
From: Dean Scott [mailto:ScottD(at)FamilyMeds(dot)com]
Sent: Thursday, March 14, 2002 9:30 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Adding a Language and Creating a Function

Hi,
I'm relatively new to PostgreSQL and have a need to create a function with
PL/pgSQL.

When I use the createlang utility:
createlang -U postgres -L /usr/lib/pgsql plpgsql dbname

I get:
ERROR: Load of file /usr/lib/pgsql/plpgsql.so failed: undefined symbol:
fmgr_pl_finfo
createlang: language installation failed

I have also tried from within psql using the CREATE TRUSTED PROCEDURAL
LANGUAGE command and it also fails with the same error.

I am using postgresql-7.1.3 configured from source with no configure options
on Redhat Linux 7.0

Does anyone know what I am doing wrong?

Thanks in advance

Dean

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster