Hi Andreas, On Fri, 07. Jun 2013 at 16:09:25 +0200, Andreas Neumann wrote: > If yes, you have to choose the geometry type and the primary key column - > otherwise you cannot select and add the layer. Same with Postgis, but with > Postgis there is some good autodetection (depending on the QGIS version).
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. But the oracle provider isn't very widely used, so there are probably still things that could use attention. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de committ(ed|ing) to Quantum GIS IRC: jef on FreeNode -- norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH Rheinstrasse 13, 26506 Norden GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502 _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer