[postgis-devel] CREATE LANGUAGE in postgis.sql

[Kevin Neufeld]

Right.  Unfortunately, PostgreSQL doesn't have the CREATE LANGUAGE [IF NOT EXISTS] syntax yet, so it'll have to go 
outside of the transaction block.

If we put the CREATE LANGUAGE command at the start of the postgis.sql file, but outside the block, then the first thing 
most people will see when they install PostGIS is an ERROR message ... could cause a lot of confusion.  It also means 
one can't grep the output for ERRORs when performing automatic installs.


... unless someone can thing of a cleaver way to query the pg_language table for the existence of 'plpgsql' and execute 
the create language statement appropriately ...

-- Kevin

Mark Cave-Ayland wrote:
> Paul Ramsey wrote:
> 
>> In answer to me, it's an ERROR so the transaction block will fail
>> unless we do it outside the block.
> 
> Yeah, that was along the lines of what I was thinking...
> 
> 
> ATB,
> 
> Mark.
>