<< Click to Display Table of Contents >> Navigation:  Connectors > PostgreSQL > Limitations

 

▪Direct procedure calls are not currently supported because of limitations in the Postgres JDBC Driver. To invoke Postgres stored procedures via DTS, please wrap them as stored functions.

▪Function overloading is not supported - a single version of a function will be available in DTS and it cannot be controlled which.

▪Enumeration, External, Range and Shell user-defined types are not currently supported.

▪The "line" native geometry type (representing an infinite straight line) is not currently supported.

▪The "box3d" native geometry type is not currently supported.

▪User-defined types containing Postgres native (non-PostGIS) geometries ("box", "box2d", "box2df", "circle", "lseg", "path", "point", "polygon") within their structure are not supported as function arguments. These types of geometry can be passed to functions as direct arguments, or PostGIS geometries (geometry, geography) can be used instead, as these are supported in any structure. This limitation does not apply to output data (table columns, function outputs).

▪Only 2D PostGIS geometries are currently supported.

▪The GEOMETRYCOLLECTION PostGIS (ST) geometry type is not currently supported.

▪Functions returning cursors are not supported.