db-sync icon indicating copy to clipboard operation
db-sync copied to clipboard

Database tables with inheritance do not work

Open wonder-sk opened this issue 2 years ago • 1 comments

It looks like when the database uses inheritance, db-sync / geodiff get confused about the table schema and init fails. We should either detect this and fail early saying that this is not supported, or fix it...

wonder-sk avatar Mar 14 '23 16:03 wonder-sk

Sample SQL that uses inheritance and breaks db-sync: https://raw.githubusercontent.com/kartoza/smallfarming-gis/96873e78d84d24d07de30fc31531b18b08072380/sql/farming.sql

wonder-sk avatar Mar 16 '23 15:03 wonder-sk