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
mysql procedure) the import fails with
:
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
ERROR: syntax error at or near ")"
LINE 1: ...0190307103908Z',replace('obsolete\n','\n',char(10)),2507,1);
^
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
:
This is fatal. My sqlite database got pretty huge. I'd love to move to
postgresql 15 to improve performance.
BTW, xca 2.5.0 was released a few days ago.
Regards
Harri
