[Qgis-developer] DB Manager and other PostGIS issues: notes from a course

[Nyall Dawson]

On 22 November 2016 at 05:03, Giovanni Manghi <giovanni.manghi at gmail.com> wrote:
> Hi all,
>
>
>> Hi,
>> thanks Giovanni for the feedback. Replies below.
>>
>> Il 21/11/2016 12:01, Giovanni Manghi ha scritto:
>>
>>>> * DB Manager
>>>>   * create table: field types are limited; in particular, timestamptz is
>>>> missing
>>>
>>> old issue, old as db manager, it only shows a subset of available datatypes.
>>
>> do you know whether there is a ticket on this?
>
> https://hub.qgis.org/projects/quantum-gis/issues?query_id=107
>
>
>
>>> the OGR based tool is necessary because is the only one available that
>>> is fast enough. It is 8+ times faster than any other tool available in
>>> QGIS making it the only tool good enough to import into postgis large
>>> layers.
>>
>> Yes, I know. Why keeping the other than?
>
> The QGIS based one is much more straightforward for the vast majority
> of cases because it does not have all the advanced options that the
> ogr based one has. In general I'm very much in favor of keeping
> diversity in Processing.

Also keep in mind that only the QGIS one fully supports QGIS layers,
including all the available field and geometry types. The OGR one also
does not have full support for all the QGIS data providers
(mssql/db2/memory layers).

For this reason I do not want to see the native QGIS one go. I'd
rather we improved QGIS core so that writing layers is faster, and
then dropped the OGR ones ;)

Nyall

>
>
>
> cheers
>
> -- G --
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer