-----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----- _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer