[postgis-users] Changing default SRID

strk strk at keybit.net
Tue Mar 30 02:28:53 PST 2004


On Tue, Mar 30, 2004 at 11:46:54AM +0200, Markus Schaber wrote:
> Hi,
> 
> When geometryfromtext() is called without a SRID, or PostGIS does an
> autoconvert, it uses an SRID of -1. Is this value configurable?
> 
> (I understand that this value has to be at least a database wide default
> because at the time of conversion, the Server does not know in which
> table the values are to be inserted.)

There is currently no #define for it.
You'll have to change it manually everywhere you need.
As an alternative you can use triggers to set a SRID, this would
be table-level (and could also be row-level).

--strk;

> 
> Thanks,
> Markus
> 
> -- 
> markus schaber | dipl. informatiker
> logi-track ag | rennweg 14-16 | ch 8001 zürich
> phone +41-43-888 62 52 | fax +41-43-888 62 53
> mailto:schabios at logi-track.com | www.logi-track.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list