Bug#1053757: migration from sqlite to postgresql 15 failed

2024-02-13 Thread Harald Dunkel
Hi Thomas, sorry for the late response. Somehow this went out of focus. I have backported your 2.5.0 package too bookworm. After running the new xca the sqlite db was updated, next I exported it using sqlite3, but on importing it psql complained about the first line in the dump file again:

Bug#1053757: migration from sqlite to postgresql 15 failed

2023-10-10 Thread Harald Dunkel
Package: xca Version: 2.4.0-2+b1 Migrating from sqlite to postgresql 15 (as described on https://hohnstaedt.de/xca/index.php/documentation/remote-databases) fails. The first line in the sqlite3 dump "PRAGMA foreign_keys=OFF;" is not accepted on import. After removing the line (similar to the