Ticket #1235 (closed defect: invalid)
cast to unknown-srid typmod fails
|Reported by:||strk||Owned by:||pramsey|
This brief session seems inconsistent to me:
strk=# select st_srid(geom::geometry('multipolygon', 0)) from poly; st_srid --------- 4326 (1 row) strk=# select st_srid(geom::geometry('multipolygon', 2)) from poly; ERROR: Geometry SRID (4326) does not match column SRID (2)
Basically the first cast attempt silently fails (the returned geometry has still the original srid, rather than the one I requested: 0).