Postgres Pro
Downloads
Home   >   mailing lists

Re: Create Language Error - Mailing list pgsql-general

From jakot05
Subject Re: Create Language Error
Date
Msg-id 6db8772f0812151941j729daf9bm3985b3a589311ed1@mail.gmail.com
Whole thread Raw
In response to Create Language Error  (jakot05 <jakot05@gmail.com>)
List pgsql-general
Tree view
On Tue, Dec 16, 2008 at 12:41 AM, jakot05 <jakot05@gmail.com> wrote:

On Mon, Dec 15, 2008 at 11:32 PM, Klint Gore <kgore4@une.edu.au> 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@une.edu.au



pgsql-general by date:

Previous
From: Sebastian Böhm
Date:
Subject: Re: tup_returned/ tup_fetched
Next
From: Martin Roach
Date:
Subject: Lost password