Re: [HACKERS] PL/pgSQL definition

>
> --postgresql-v6.4/src/pl/plpgsql/src/INSTALL says:
> ...
>         If you declare the language in the template1 database,
>         any subsequently created database will have PL/pgSQL
>         support installed automatically.
>
>
> --I declared PL/pgSQL in the template1 database but I have an ERROR
> message when I try to
> --use PL/pgSQL language in another database.
>
>
> ERROR:  Unrecognized language specified in a CREATE FUNCTION:
> 'plpgsql'.  Recogn
> ized languages are sql, C, internal and the created procedural
> languages.
>
> --Seems that I  must to declare PL/pgSQL in every database.
> --Any ideas?
>

    You  must declare PL/pgSQL in template1 BEFORE you create the
    other databases. At createdb time, the template1 database  is
    copied  into  the  new created database. All definitions, you
    made until then are automatically in the new db. So you could
    also  create  tables, functions and anything else you want to
    have by default in any new db.

> --Please relply to sferac@bo.nettuno.it
>
> --Jose-
>
>


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #