Thread: Updated to 7.2 now can't createlang..
When I try to do a createlang plpgsql template1 (or any other pl...) I get a message about the plpgsql_call_handle doesn't exist?? I get the same error if I try to plpgsql long-hand by doing a CREATE FUNCTION. Just a FYI that may clue someone in: I just got a new box so I immediately installed 7.2 before creating a new database. After install I changed PGDATA to a new directory and then did my initdb. Template1 create with the default Languages installed. TIA -Patrick Patrick Hatcher Macys.Com Legacy Integration Developer 415-932-0610 office
"Patrick Hatcher" <PHatcher@macys.com> writes:
> When I try to do a createlang plpgsql template1 (or any other pl...) I get
> a message about the plpgsql_call_handle doesn't exist?
Could you show us the exact output from "createlang -e plpgsql yourdb"?
regards, tom lane
Have you tried createlang --L /usr/local/pgsql/lib plpgsql template1 from the command prompt of your linux box http://www.pgexplorer.com GUI Tool for Postgtes ----- Original Message ----- From: "Patrick Hatcher" <PHatcher@macys.com> To: <pgsql-novice@postgresql.org> Sent: Saturday, February 16, 2002 10:12 PM Subject: [NOVICE] Updated to 7.2 now can't createlang.. > When I try to do a createlang plpgsql template1 (or any other pl...) I get > a message about the plpgsql_call_handle doesn't exist?? I get the same > error if I try to plpgsql long-hand by doing a CREATE FUNCTION. > > Just a FYI that may clue someone in: > I just got a new box so I immediately installed 7.2 before creating a new > database. After install I changed PGDATA to a new directory and then did > my initdb. Template1 create with the default Languages installed. > > TIA > -Patrick > > Patrick Hatcher > Macys.Com > Legacy Integration Developer > 415-932-0610 office > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html
Thanks PG..
Ah....Sorry everyone. Still wet behind the ears on Postgres. I made the
mistake of trying to create the language from within the Postgres database.
Once I got out and did it from the command line as PG suggested, it was
created.
Thanks again for the help
Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-932-0610 office
"PG Explorer"
<pgmail@pgexplorer.com> To: <pgsql-novice@postgresql.org>, "Patrick
Sent by: Hatcher" <PHatcher@macys.com>
pgsql-novice-owner@post cc:
gresql.org Subject: Re: [NOVICE] Updated to 7.2 now can't
createlang..
02/16/2002 12:39 PM
Have you tried
createlang --L /usr/local/pgsql/lib plpgsql template1
from the command prompt of your linux box
http://www.pgexplorer.com
GUI Tool for Postgtes
----- Original Message -----
From: "Patrick Hatcher" <PHatcher@macys.com>
To: <pgsql-novice@postgresql.org>
Sent: Saturday, February 16, 2002 10:12 PM
Subject: [NOVICE] Updated to 7.2 now can't createlang..
> When I try to do a createlang plpgsql template1 (or any other pl...) I
get
> a message about the plpgsql_call_handle doesn't exist?? I get the same
> error if I try to plpgsql long-hand by doing a CREATE FUNCTION.
>
> Just a FYI that may clue someone in:
> I just got a new box so I immediately installed 7.2 before creating a new
> database. After install I changed PGDATA to a new directory and then did
> my initdb. Template1 create with the default Languages installed.
>
> TIA
> -Patrick
>
> Patrick Hatcher
> Macys.Com
> Legacy Integration Developer
> 415-932-0610 office
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster