Re: [Dxf2postgis-discussion] Dxf2PostGIS - two suggestions to improve

[Guglielmo N. <g....@gl...>]

> Hello list,
Hello Astrid,

> we are using the Dxf2PostGIS-Konverter and it's really working fine and
> very fast.
>
> We have two suggestions to make.
>
> 1. How to create serial-columns and geometry columns
> - it would be better to create searial columns like:
>
>  CREATE TABLE abwasser.sinkkaesten_txt
>  (
>    gid serial,
>    ....
>
> Like this the database can decide, how this this serial is created. We had
> problems with older postgresql versions with the way the sequence is
> produces at the moment.
>   
Ok, we'll look into this.
> Similar case is the geometry-column:
>
> It would be better to create it with
>
>  Select AddGeometryColumn ('myschemaname','abwasser', 'sinkkaesten_txt',
> 'the_geom',  31466,'POINT',2);
>
> and not writing it in the table directly. Here aswell we had problems with
> older versions, as the constraints where different and for example the
> function ndims was not known i our version
>
>   
I totally agree. This must have been overlooked since the beginning. 
Thanks for pointing it out.
> 2. Possibility to use a schema
> In our database we use schemata to group our data. It would be very cool,
> if Dxf2PostGIS could handle schema aswell. It would be another textfield
> schemaname:
>
> If a schema is should be used there a tree changes necessary:
> - CREATE TABLE myschemaname.mytable....
> - Select AddGeometryColumn ('myschemaname','mytable', 'sinkkaesten_txt',
> 'the_geom',  31466,'POINT',2);
> - INSERT INTO myschemaname.mytable...
>
>   
Agreed. Schema support will be present in the next releases.
> What do you think about the suggestions?
>   
Very useful! Thank you for your suggestions.
> Greetings from Germany
>
> Astrid Emde
>
>   
Greetings from Rome too :-)

    Guglielmo Nigri
    Glasic S.r.l.