Thread: Adding a Language and Creating a Function

Adding a Language and Creating a Function

From
Dean Scott
Date:
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

Re: Adding a Language and Creating a Function

From
Dean Scott
Date:
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@FamilyMeds.com]
Sent: Thursday, March 14, 2002 9:30 AM
To: pgsql-general@postgresql.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