Обсуждение: RE: [SQL] plpgsql error

Look in the docs for create language.  You need to execute a create language
command to tell postgres to recognize plpgsql.  I believe the library is
created as part of the install process.

> -----Original Message-----
> From:    Adam H. Pendleton [SMTP:apendleton@vgsinc.com]
> Sent:    Monday, May 10, 1999 2:32 PM
> To:    pgsql-sql@hub.org
> Subject:    [SQL] plpgsql error
> 
> I get this error when I try to create a function using plpgsql:
> 
> ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
> Recognized languages are sql, C, internal and the created procedural
> languages.
> 
> Do I need to specify another flag when I compile Postgresql?
> 
> Adam
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Si hoc legere scis nimium eruditionis habes.
> 
> 

Michael J Davis <michael.j.davis@tvguide.com> writes:
> Look in the docs for create language.  You need to execute a create language
> command to tell postgres to recognize plpgsql.  I believe the library is
> created as part of the install process.

plpgsql isn't installed into the system by default; you have to do the
appropriate incantation after installing and starting the base Postgres
system.  ISTR there is a shell script you should run to do all that's
needful --- look in the plpgsql docs and/or source files.
        regards, tom lane