how can I delete the values ​​of the table f_table_name: geometry_columns

31 views
Skip to first unread message

ugo montorsi

unread,
Jun 1, 2016, 7:02:13 AM6/1/16
to SpatiaLite Users
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;
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-01";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-01_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-03";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-03_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-04";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-04_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-05";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-05_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-07";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-07_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-08";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-08_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-09";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-09_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-10";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-10_1"
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-27"
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-27_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-28";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-28_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-30";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-06-30_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-01";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-01_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-02";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-02_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-03";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-03_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-10";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-10_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-11";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-18";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-21";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-07-23";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-08-12";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-08-12_1";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-08-27";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-08-28";
DELETE FROM geometry_columns
WHERE f_table_name = "gv_agea_veneto_2015-08-29";
DELETE FROM geometry_columns
WHERE f_table_name = "padova";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli1";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli10";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli11";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli12";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli13";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli14";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli15";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli16";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli17";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli18";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli19";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli2";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli20";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli21";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli22";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli23";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli3";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli4";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli5";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli6";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli7";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli8";
DELETE FROM geometry_columns
WHERE f_table_name = "provincevoli9";
DELETE FROM geometry_columns
WHERE f_table_name = "rovigo";
DELETE FROM geometry_columns
WHERE f_table_name = "sezioniprovinceregioneveneto";
DELETE FROM geometry_columns
WHERE f_table_name = "sezioniregioneveneto";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli1";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli10";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli11";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli12";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli13";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli14";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli15";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli16";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli17";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli18";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli19";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli2";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli20";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli21";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli22";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli23";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli3";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli4";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli5";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli6";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli7";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli8";
DELETE FROM geometry_columns
WHERE f_table_name = "sezionivenetovoli9";
DELETE FROM geometry_columns
WHERE f_table_name = "Treviso";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150601";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150603";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150604";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150605";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150607";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150608";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150609";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150610";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150627";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150628";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150630";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150701";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150702";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150703";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150710";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150711";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150718";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150721";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150723";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150812";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150827";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150828";
DELETE FROM geometry_columns
WHERE f_table_name = "veneto20150829";
DELETE FROM geometry_columns
WHERE f_table_name = "venetopianivoli";
DELETE FROM geometry_columns
WHERE f_table_name = "Venice";
DELETE FROM geometry_columns
WHERE f_table_name = "Verona";
DELETE FROM geometry_columns
WHERE f_table_name = "Vicenza";
COMMIT;


how can I delete the values ​​of the table f_table_name: geometry_columns

thanks for your help,

regards,

Ugo

a.fu...@lqt.it

unread,
Jun 1, 2016, 7:27:33 AM6/1/16
to spatiali...@googlegroups.com
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

Reply all
Reply to author
Forward
0 new messages