I am in the process of restoring a database that relied on PostGIS version 1.5 functions to a newer Postgresql engine that leverages PostGIS 2.2 functions. In my restore process, I receive the following error:
pg_restore: [archiver (db)] could not execute query: ERROR: function srid(geometry) does not exist.
I know this error is caused by a constraint on one of my tables that utilizes the srid(geometry) function. I want to alter the constraint to use the new function name -- if it exists. Has this function been removed or has it been renamed since PostGIS version 1.5?
I am unable to use the legacy PostGIS functions because I am restoring to an AWS RDS instance. RDS instances do not allow the creation of functions that use C language libraries from the underlying OS for security reasons. That is why I am in this situation.