ERROR: PLPGSQL does not exist

From: "Amin Schoeib" <aschoeib(at)4tek(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: PLPGSQL does not exist
Date: 2003-09-03 09:44:30
Message-ID: 70DD6153277512439CA4B66956A3098132D07C@pdc.4tek-net.4tek.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-09-03 09:59:11 Re: ERROR: PLPGSQL does not exist
Previous Message Malcolm Warren 2003-09-03 09:39:14 Re: Using oids