RE: pl/pgSQL

> -----Original Message-----
> From: Jason Tishler [mailto:Jason(dot)Tishler(at)dothill(dot)com]
> Sent: 05 July 2001 14:46
> To: Dave Page
> Cc: 'pgsql-cygwin(at)postgresql(dot)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.