> I try to create the next function:
> create function ttt() RETURNS OPAQUE AS '
> RAISE EXCEPTION "Hello"
> END' language 'plpgsql';
> The result is:
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
> Recognized languages are sql, C, internal and the created procedural languages.
> I have postgres SQL ver. 6.5.2.
> What's going on?
As the message says, only the created procedural languages
can be recognized. You haven't enabled the language and it
isn't installed by default. Use
to install it in your database. If you install it in the
template1 database, than all subsequent created databases
automatically inherit this.
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck(at)debis(dot)com (Jan Wieck) #
In response to
pgsql-sql by date
|Next:||From: Lars||Date: 2000-02-08 19:08:11|
|Subject: Re: [SQL] SubSelect as a column|
|Previous:||From: Tom Lane||Date: 2000-02-08 15:57:46|
|Subject: Re: [SQL] Problem with PL/pgSQL |