[postgis-devel] Is it possible to get rid of platform specific lwpostgis.sql files?

[Tom Lane]

Charlie Savage <cfis at savagexi.com> writes:
> The PostGis installation scripts generate different versions of 
> lwpostgis.sql per platform.

> For example, here is Affine defined on Linux and Windows:

> CREATE OR REPLACE FUNCTION 
> Affine(geometry,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8)
> 	RETURNS geometry
> 	AS '$libdir/liblwgeom.so.1.3', 'LWGEOM_affine'
> 	LANGUAGE 'C' IMMUTABLE STRICT;


> CREATE OR REPLACE FUNCTION 
> Affine(geometry,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8,float8)
> 	RETURNS geometry
> 	AS '$libdir/liblwgeom.dll', 'LWGEOM_affine'
> 	LANGUAGE 'C' IMMUTABLE STRICT;

> Notice the library names are different. However, if you look at other 
> postgresql contrib modules they don't do this.

This is definitely deprecated practice --- you should rely on dfmgr to
supply the appropriate platform-specific extension.

			regards, tom lane