[QGIS-Developer] duplicate oracle views displayed in the layer list

[Jürgen E. Fischer]

Hi Richard,

On Wed, 06. Oct 2021 at 07:54:57 +0200, Richard Duivenvoorde wrote:
> /me wildly guessing here: if QGIS 'sees' different geom types, it is shown
> multiple in the browser isn't it, or am I mixing up things here..? Like if a
> layer has both points and lines?

There is no geometry type constraint in Oracle, so you can have any geometry
type - even ones that don't yet exists.  So you get one line for each existing
geometry type (point, line, area) and one where you have to select the geometry
type in case you want to add a not yet existing geometry type.

Same happens for GEOMETRY columns (instead limited to POINT, LINESTRING or
POLYGON) in postgres.


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            https://www.norbit.de
QGIS release manager (PSC)  Germany                 IRC: jef on Libera|OFTC
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 827 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20211006/945ca5d7/attachment.sig>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: Pflichtangaben
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20211006/945ca5d7/attachment.ksh>