On Mon, 13 Sep 2021 01:07:01 -0700 (PDT), Antonio Valanzano wrote:
> So using the GUI and
> not having the possibility of recompiling the library using the "
> -DSQLITE_ALLOW_ROWID_IN_VIEW compile-time option "
> the only solution seems to be:
> 1. to "clone" the table into a new table
> 2. to remove the old table.
there is a simplest workaround. just execute:
DROP TRIGGER ISO_metadata_reference_row_id_value_insert;
DROP TRIGGER ISO_metadata_reference_row_id_value_update;
the issue is caused by an incorrect SQL statement in these
two triggers; if you are not currently using the ISO matadata
module (as I presume) removing both triggers is completerly
harmless and will definitively resolve this annoying issue.