ERROR: PLPGSQL does not exist - Mailing list pgsql-general

From Amin Schoeib
Subject ERROR: PLPGSQL does not exist
Date
Msg-id 70DD6153277512439CA4B66956A3098132D07C@pdc.4tek-net.4tek.de
Whole thread Raw
Responses Re: ERROR: PLPGSQL does not exist
Re: ERROR: PLPGSQL does not exist
List pgsql-general

Hi,
When I Try to write Functions I always become the error
That the language plpgsql doesn't exist.
I tried it this way:
createlang plpgsql template1
createlang -l template1

Procedural languages
  Name   | Trusted?
---------+----------
 plpgsql | t
(1 row)

I also restart the database but no effect.
What am I doing wrong??
Sorry but I'm a Postgres newbie. I worked until yet with Oracle and now we want to change
On Postgres.

Best regards

Schoeib

4Tek Gesellschaft für angewandte Informationstechnologien mbH
Schoeib Amin
Tel.  +49 (0) 69 697688-132
Fax. +49 (0) 69 697688-111
http://www.4tek.de

pgsql-general by date:

Previous
From: Malcolm Warren
Date:
Subject: Re: Using oids
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: ERROR: PLPGSQL does not exist