From: | James Cradock <jcradock(at)me3(dot)com> |
---|---|
To: | eoghan <postgres(at)redry(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: createlang |
Date: | 2005-08-15 21:03:09 |
Message-ID: | df7a444ca8f05be961e974f8b9c4c29f@me3.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Almost forgot:
http://www.postgresql.org/docs/8.0/interactive/app-createlang.html
I hope this and the prior reply help.
On Aug 15, 2005, at 4:45 PM, eoghan wrote:
> Hello
> Im trying to load plpgsql into my test db... Im wondering if theres a
> way to check if its loaded... I do:
> test-# createlang plpgsql test
> test-#
> When i try load an example function:
> test-# \i test.sql
> Im getting:
> psql:test.sql:5: ERROR: language "plpgsql" does not exist
> HINT: You need to use "createlang" to load the language into the
> database.
> Anyone any hints for me?
> Thanks
> Eoghan
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
-----
James Cradock, jcradock(at)me3(dot)com
me3 Technology Consultants, LLC
24 Preble Street, 2nd Floor
Portland, ME 04101
207-772-3217 (office)
207-838-8678 (mobile)
From | Date | Subject | |
---|---|---|---|
Next Message | eoghan | 2005-08-15 21:05:00 | Re: createlang |
Previous Message | James Cradock | 2005-08-15 21:01:29 | Re: createlang |