Revision history [back]

Without knowledge of the specific error message or the current data type of the latitude and longitude columns, it is difficult to provide a specific solution for this problem. However, some general troubleshooting steps that can help resolve issues related to altering data types in PostgreSQL include:

1. Ensure that the table and columns being altered exist in the database and are spelled correctly.
2. Verify that there are no constraints or indexes on the columns being altered that could prevent the change.
3. Check for compatibility issues between the current and desired data types, such as precision or length requirements.
4. Ensure that there are no conflicts with existing data in the columns, such as values that violate the new data type constraints.
5. Try using a cast function to convert the data type temporarily before altering the column data type.

If these steps do not resolve the issue, further investigation into the specific error message or consulting with a PostgreSQL expert may be necessary.