Thread: Updated to 7.2 now can't createlang..

Updated to 7.2 now can't createlang..

From
"Patrick Hatcher"
Date:
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





Re: Updated to 7.2 now can't createlang..

From
Tom Lane
Date:
"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

Re: Updated to 7.2 now can't createlang..

From
"PG Explorer"
Date:
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


Re: Updated to 7.2 now can't createlang..

From
"Patrick Hatcher"
Date:
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