[Dxf2postgis-discussion] Dxf2PostGIS - two suggestions to improve

[Astrid E. (WhereGroup) <ast...@wh...>]

Hello list,

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.

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


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...

What do you think about the suggestions?

Greetings from Germany

Astrid Emde

----------------------------------

  Astrid Emde
  WhereGroup GmbH & Co.KG
  Siemensstraße 8
  D-53121 Bonn

  Fon: +49(0)228 90 90 38 - 19
  Fax: +49(0)228 90 90 38 - 11

  ast...@wh...
  http://www.wheregroup.com