On Wed, 1 Jun 2016 04:02:13 -0700 (PDT), ugo montorsi wrote:
> hi,
> I have to remove from the table geometry_columns values
> f_table_name, but I get this error message:
>
> "SQLite SQL error: cannot start a transaction within a transaction"
>
> the query that I'm launching it:
>
> BEGIN;
>
Hi Ugo,
you are simply experiencing a very trivial SQL error
caused by your own previous actions.
please note: this has absolutely nothing specifically
related to SpatiaLite; it's a generic error caused by
misusing SQL statements.
SQLite (accordingly to SQL specifications) forbids to
start a new transaction if a previously declared
transaction is still pending; that's exactly what
the error message complaints about:
"cannot start a transaction within a transaction"
you obviously have an unfinished transaction declared
in some previous step and still expecting to be closed
by executing a COMMIT (or ROLLBACK) statement.
please correct your own SQL script and retry again.
bye Sandro