[QGIS-Developer] Save as PG dump create obsolete dumps

[Nyall Dawson]

On Sat, 10 Oct 2020 at 00:52, Paolo Cavallini <cavallini at faunalia.it> wrote:
>
> Hi all,
> this is what it is produced:
>
> SET standard_conforming_strings = OFF;
> DROP TABLE IF EXISTS "public"."test_export" CASCADE;
> DELETE FROM geometry_columns WHERE f_table_name = 'test_export' AND
> f_table_schema = 'public';
> BEGIN;
> CREATE TABLE "public"."test_export" ( "ogc_fid" SERIAL, CONSTRAINT
> "test_export_pk" PRIMARY KEY ("ogc_fid") );
> SELECT
> AddGeometryColumn('public','test_export','wkb_geometry',4326,'LINESTRING',2);

Is this through the standard right click layer - export functionality?
If so, the SQL is being created by GDAL, not QGIS, so this should be
raised as a GDAL ticket.

Nyall

> ...
>
> Why it is not using the modern syntax, with standard geom name
>
> geom GEOMETRY(LineString, 4326));
> ?
>
> All the best.
> --
> Paolo Cavallini
> www.faunalia.eu - QGIS.org
> training, support, development on QGIS, PostGIS and more
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer