From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Jason Tishler'" <Jason(dot)Tishler(at)dothill(dot)com> |
Cc: | "'pgsql-cygwin(at)postgresql(dot)org'" <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | RE: pl/pgSQL |
Date: | 2001-07-05 14:05:53 |
Message-ID: | 8568FC767B4AD311AC33006097BCD3D61A2CD6@woody.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Tishler | 2001-07-05 14:12:26 | Re: pl/pgSQL |
Previous Message | Jason Tishler | 2001-07-05 13:46:15 | Re: pl/pgSQL |