Postgres Pro
Downloads
Home   >   mailing lists

Thread: Create Language Error

Create Language Error

From
jakot05
Date:
Hi!

Im trying to install sql-ledger but I got:
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database

...then I use CREATE LANGUAGE, but;

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

My system:
Ubuntu 8.04
postgresql 8.3.5
sql-ledger 2.6.22
apache  2.2

Thanks for any hint!

Re: Create Language Error

From
Adrian Klaver
Date:
On Monday 15 December 2008 6:24:50 pm jakot05 wrote:
> Hi!
>
> Im trying to install sql-ledger but I got:
> ERROR: language "plpgsql" does not exist
> HINT: Use CREATE LANGUAGE to load the language into the database
>
> ...then I use CREATE LANGUAGE, but;
>
> postgres=# CREATE LANGUAGE pgpsql

plpgsql  not pgpsql

> postgres-# ;
> ERROR: unsupported language «pgpsql»
> HINT: The supported languages are listed in the pg_pltemplate
>
> ... don't know what im doing wrong :-S
>
> My system:
> Ubuntu 8.04
> postgresql 8.3.5
> sql-ledger 2.6.22
> apache  2.2
>
> Thanks for any hint!



--
Adrian Klaver
aklaver@comcast.net

Re: Create Language Error

From
jakot05
Date:
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