Postgres Pro
Downloads
Home   >   mailing lists

Re: Unrecognized language plpgsql when CREATE FUNCTION?! - Mailing list pgsql-general

From Raymond Chui
Subject Re: Unrecognized language plpgsql when CREATE FUNCTION?!
Date
Msg-id 3A796B1C.AAE9DD67@noaa.gov
Whole thread Raw
In response to Unrecognized language plpgsql when CREATE FUNCTION?!  (Raymond Chui <raymond.chui@noaa.gov>)
List pgsql-general
Tree view 
Be default PL/PGSQL is not installed in each database. You must type

createlang --host=hostname --port=5432 --username=postgres --dbname=yourdb
--pglib=$PGLIB plpgsql yourdb

To verify type

createlang -l yourdb

--Raymond
Attachment

pgsql-general by date:

Previous
From: Brice Ruth
Date:
Subject: SQL Join - MySQL/PostgreSQL difference?
Next
From: Patrick Welche
Date:
Subject: Re: undefined reference to xxx