RE: pl/pgSQL

> -----Original Message-----
> From: Jason Tishler [mailto:Jason.Tishler@dothill.com]
> Sent: 05 July 2001 14:46
> To: Dave Page
> Cc: 'pgsql-cygwin@postgresql.org'
> Subject: Re: pl/pgSQL
>
>
> Dave,
>
> On Thu, Jul 05, 2001 at 10:19:44AM +0100, Dave Page wrote:
> > Do you think it would be possible to build PostgreSQL with pl/pgsql
> > for future Cygwin releases?
>
> Huh?  PL/pgSQL has built OOTB since PostgreSQL 7.0.2 (when I
> started to provide Cygwin PostgreSQL patches) and possibly
> earlier.  Anyway it is already on your PC:
>
>     $ ls /usr/lib/plpgsql.dll
>     /usr/lib/plpgsql.dll

Hi Jason,

Yes, the DLL is there, but the language is not installed:

template1=# select * from pg_language;
 lanname  | lanispl | lanpltrusted | lanplcallfoid | lancompiler
----------+---------+--------------+---------------+-------------
 internal | f       | f            |             0 | n/a
 C        | f       | f            |             0 | /bin/cc
 sql      | f       | f            |             0 | postgres
(3 rows)

I was under the impression (wrongly :-)) that ./configure --with-plpgsql
installed the language in the relevant template files so that initdb would
include it in template1. Closer inspection of the Makefile proves this is
not the case - I'll just use createlang...

Just ignore me. I'll probably go away eventually :-)

Regards, Dave.