From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
---|---|
To: | Amin Schoeib <aschoeib(at)4tek(dot)de> |
Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ERROR: PLPGSQL does not exist |
Date: | 2003-09-03 10:02:09 |
Message-ID: | 1062583329.15712.65.camel@coppola.ecircle.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
You are creating the plpgsql language on the template1 database.
From now on it will be available in all __newly created__ database
(cause template1 is the template of new DBs, as it's name suggests), but
not in your already existing ones... there you must create it
explicitly:
createlang plpgsql your_existing_db_name
HTH,
Csaba.
On Wed, 2003-09-03 at 11:44, Amin Schoeib wrote:
>
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bo Lorentsen | 2003-09-03 10:20:42 | Re: Using oids |
Previous Message | Shridhar Daithankar | 2003-09-03 09:59:11 | Re: ERROR: PLPGSQL does not exist |