Re: Create Language Error

[jakot05 <jakot05@xxxxxxxxx>]

On Tue, Dec 16, 2008 at 12:41 AM, jakot05 <jakot05@xxxxxxxxx> wrote:

On Mon, Dec 15, 2008 at 11:32 PM, Klint Gore <kgore4@xxxxxxxxxx> wrote:

jakot05 wrote:

postgres=# CREATE LANGUAGE pgpsql
postgres-# ;
ERROR: unsupported language «pgpsql»
HINT: The supported languages are listed in the pg_pltemplate

... don't know what im doing wrong :-S

You have to put the "pl" on the front of it.

CREATE LANGUAGE plpgsql;

klint.

 

Thanks a lot Adrian and Klint!, its works :-)
 

--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789  Fax: 02 6773 3266
EMail: kgore4@xxxxxxxxxx