error: "st_extent" is an aggregate function about pg-diff HOT 4 CLOSED

@atonse

We will investigate connection problems with PostGIS, for now it is not supported.
From my understanding seems a problem with node-postgres library.

Happy new year 😄

from pg-diff.

@michaelsogos PostGIS is a plugin for Postgres, so we are actually just running vanilla Postgres. It's likely that to support PostGIS (not asking for support of PostGIS necessarily, because I mostly want my PG tables compared), you'd have to ignore st_* functions and it would already work.

However as I write this, I realize if you are doing data diffing, you'll initially want to ignore geometry tables. So maybe not so easy :-)

from pg-diff.

Hi @atonse
PostGIS is one of the most famous extension/distro for Postgre.
It is our intention to officially support it.

We are working on it and before proceed with a simple "ignore st_* table" we would like to investigate deeply.

Thanks to support our library, we appreciate it.

from pg-diff.

Hi @atonse ,

We released verison 1.2.13 that should resolve your issue.
Can you eventually let me know if it works for you?

Changelog:

• Updated to pg 8.1.0
• Exlusion of object created by extensions
• Support for any data type declared as USER DEFINED (like geometry 😄)
• Support POSGIS and PG_CRYPTO also in data compare

from pg-diff.