function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist

I have enabled the postgis extension, created a table and ran

SELECT AddGeometryColumn('public','address_point_extract_wgs84','geom',4326,'POINT',3);

SELECT AddGeometryColumn('public','address_point_extract_wgs84','geom',4326,'POINT',3);

the result was

Failed to run sql query: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist

Failed to run sql query: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist

This has worked before so I am lost... Any advice would be helpful.

Supabase•4y ago•

3 replies

I have enabled the postgis extension, created a table and ran

SELECT AddGeometryColumn('public','address_point_extract_wgs84','geom',4326,'POINT',3);

SELECT AddGeometryColumn('public','address_point_extract_wgs84','geom',4326,'POINT',3);

the result was

Failed to run sql query: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist

Failed to run sql query: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist

This has worked before so I am lost... Any advice would be helpful.