Gabriel Bordeaux

Do you mean running the following before the migrations? ```sql SET TRANSACTION ISOLATION LEVEL READ COMMITTED; ```` Then wrapping all updates with: ```sql START TRANSACTION; UPDATE ....; COMMIT; ```

Hi @bkanuka , if they both have the data type and they work the same way, it's easy to add and I am happy to do it but would you...

@bkanuka I can see the data type on PostGIS here: https://postgis.net/docs/reference.html#PostGIS_Types However on BQ I checked https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types and https://cloud.google.com/bigquery/docs/geospatial-data and I do not see `GEOMETRY`, only `GEOGRAPHY`, are they interchangeable...

@bkanuka Ok Sounds good! I created this PR: https://github.com/gabfl/bigquery_fdw/issues/30 I mapped both PostGIS types `geometry` and `geography` to BigQuery's `GEOGRAPHY` data type. Can you try it and let me know?...

@bkanuka did you get a chance to review this?

@stuieordie if you want to file a Pull Request, please feel free to. Otherwise, I do think it's a good idea and may do it when I have time but...