Skip site navigation (1) Skip section navigation (2)

RE: pl/pgSQL

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 (view raw or flat)
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.

Responses

pgsql-cygwin by date

Next:From: Jason TishlerDate: 2001-07-05 14:12:26
Subject: Re: pl/pgSQL
Previous:From: Jason TishlerDate: 2001-07-05 13:46:15
Subject: Re: pl/pgSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group