4. Geospatial Data Types : Spatial Reference Systems : SRID Restrictions
 
Share this page                  
SRID Restrictions
The following syntax does not work:
CREATE TABLE cras AS SELECT PointFromText('POINT(1 1)', 123);
but the following syntax works:
CREATE TABLE cras AS SELECT PointFromText('POINT(1 1)');
If a literal is used in a CREATE TABLE AS SELECT statement, the SRID cannot be looked up because there is no physical table behind it. Ingres by default assigns an SRID of -1, which works in the second example. You can always do an ALTER TABLE ALTER COLUMN to change the SRID after the table is created.