Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql language not recognized - Mailing list pgsql-novice

From Tom Lane
Subject Re: plpgsql language not recognized
Date
Msg-id 16660.977415100@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql language not recognized  (David Merrill <dmerrill@lupercalia.net>)
Responses Re: plpgsql language not recognized
List pgsql-novice
Tree view 
David Merrill <dmerrill@lupercalia.net> writes:
> ERROR:  Unrecognized language specified in a CREATE FUNCTION:
> 'plpgsql'. Recognized languages are sql, C, internal and the created
> procedural languages.

plpgsql isn't installed (made available in a particular database) by
default.  Use the createlang script to make it available.

            regards, tom lane

pgsql-novice by date:

Previous
From: David Merrill
Date:
Subject: plpgsql language not recognized
Next
From: Karla Peralta
Date:
Subject: Transactions