search

MerginMaps / db-sync

A tool for two-way synchronization between Mergin Maps and a PostGIS database
https://merginmaps.com
MIT License
45 stars 20 forks source link

db sync fails to start #135

Open encleadus opened 8 months ago

encleadus commented 8 months ago

I actually experiencing two type of issues. I am using DB-SYNC 2.1.1 on windows.

I have couple of tables in a database and I am actively use row level security, to modify the availability of data to field users. Whenever I try to sync a table with activated row level security the db sync fails as it tries to add the id column two times:

Error: postgres cmd error: ERROR: column "ogc_fid" specified more than once

so I removed all the privileges setup, it did fail. I tried with postgres user it did fail. I removed my original id column and added uuid field with uuid_generate_v4() this helped to generate another error

LINE 1: UPDATE "public_db_sync"."chambers_mergin" SET  WHERE "uuid2"...
                                                       ^
SQL:
UPDATE "public_db_sync"."chambers_mergin" SET  WHERE "uuid2" = 'ffdc0ee4-6fd8-4e90-a5e3-32a975efc37c'

any help would be much appreciated

encleadus commented 8 months ago

Back to the first error, if I remove one of the existing column, the sync starts normally