Juan Ramón Cortabitarte wrote:
> Hello,
>
> I'm trying to do some store procedure in pl/pgsql but the sql server says
> me:
>
> Error: ERROR: Unrecognized language specified in a CREATE FUNCTION:
> 'plpgsql'. Recognized languages are sql, C, internal and the created
> procedural languages.
>
> I´m using Red Hat Linux 7.0 and Postgress 7.02.
> i executed:
>
> #createlang plpgsql dbhtc
>
> createlang: missing required argument PGLIB directory
createlang --username=postgres --dbname=yourdb --pglib=/usr/lib/pgsql plpgsql
yourdb
If you don't see plpgsql.so in PGLIB directory, then you better re-install
your
PostgreSQL.
begin:vcard
n:Chui;Raymond
tel;fax:(301)713-0963
tel;work:(301)713-0624 Ext. 168
x-mozilla-html:TRUE
url:http://members.xoom.com/rchui/
org:NWS, NOAA
version:2.1
email;internet:[EMAIL PROTECTED]
title:SA, DBA
note:ICQ #: 16722494
adr;quoted-printable:;;NOAA, NWS, Office of Hydrology, OH=0D=0A1325 East-West Highway, Room 8112;Silver Spring;MD;20910-3283;U.S.A.
x-mozilla-cpt:;-6384
fn:Raymond Chui
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
