Skip to main content
Geographic Information Systems

Return to Answer

Clarified that temporary database is an automatically created attached database
Source Link
user30184
user30184
  • 69k
  • 4
  • 71
  • 125

I do not believe that the AddGeometryColumn part is possible at all. This thread tells that it is not possible withto use it for attached databases https://groups.google.com/forum/#!topic/spatialite-users/rRMSHk2Lt38 and the TEMPtemporary database feels like a sort ofis an attached, automatically created database as well. You must create your temporary tables into the main database and drop them once you do not need them any more.

I do not believe that the AddGeometryColumn part is possible at all. This thread tells that it is not possible with attached databases https://groups.google.com/forum/#!topic/spatialite-users/rRMSHk2Lt38 and the TEMP database feels like a sort of attached database as well. You must create your temporary tables into the main database and drop them once you do not need them any more.

I do not believe that the AddGeometryColumn part is possible at all. This thread tells that it is not possible to use it for attached databases https://groups.google.com/forum/#!topic/spatialite-users/rRMSHk2Lt38 and the temporary database is an attached, automatically created database. You must create your temporary tables into the main database and drop them once you do not need them any more.

added 24 characters in body
Source Link
user30184
user30184
  • 69k
  • 4
  • 71
  • 125

I do not believe that itthe AddGeometryColumn part is possible at all. This thread tells that it is not possible with attached databases https://groups.google.com/forum/#!topic/spatialite-users/rRMSHk2Lt38 and the TEMP database feels like a sort of attached database as well. You must create your temporary tables into the main database and drop them once you do not need them any more.

I do not believe that it is possible at all. This thread tells that it is not possible with attached databases https://groups.google.com/forum/#!topic/spatialite-users/rRMSHk2Lt38 and the TEMP database feels like a sort of attached database as well. You must create your temporary tables into the main database and drop them once you do not need them any more.

I do not believe that the AddGeometryColumn part is possible at all. This thread tells that it is not possible with attached databases https://groups.google.com/forum/#!topic/spatialite-users/rRMSHk2Lt38 and the TEMP database feels like a sort of attached database as well. You must create your temporary tables into the main database and drop them once you do not need them any more.

Source Link
user30184
user30184
  • 69k
  • 4
  • 71
  • 125

I do not believe that it is possible at all. This thread tells that it is not possible with attached databases https://groups.google.com/forum/#!topic/spatialite-users/rRMSHk2Lt38 and the TEMP database feels like a sort of attached database as well. You must create your temporary tables into the main database and drop them once you do not need them any more.