[Qgis-developer] Oracle provider tests

[Paolo Cavallini]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il 07/06/2013 16:39, Jürgen E. Fischer ha scritto:
> QGIS needs a specific CRS (ie. SRID) and a defined geometry type (point, line,
> polygon) for each layer and offers what it finds in the database or requires to
> enter what is undefined.  You can only select the lines that are fully defined.
> 
> That's very similar in the PostGIS and Oracle dialogs.  It's just that Oracle
> doesn't have "standard" constraints, that limit the usable geometry types and
> SRIDs in a column and therefore also doesn't have a metadata table that carries
> that information, while PostGIS tables are usually quite constrainted.
> 
> So for Oracle everything except the geometry columns themselves need to be
> scanned, while for PostGIS that can be taken from the metadata table in the
> usual case with applied constraints.
> 
> If you create geometry column in PostGIS 2 with SRID 0 (meaning any) and type
> GEOMETRY (any geometry type) the outcome might be quite similar and you get a
> couple of lines for that column, each with a different combination of available
> geometry type and SRID combinations in the table plus another line where you
> can enter geometry types and SRIDs that you don't already have.

Hi.
I think these notes should be added to the User Manual.
Otto, do you agree?
All the best.

- -- 
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlGx+P0ACgkQ/NedwLUzIr5OFgCeI9Y6OfzicTSI4Vef9PNc/Vx7
CggAn1SqdYxoQ396bhyI+NqMXEUeAtES
=emp1
-----END PGP SIGNATURE-----