[#1011303] Oracle_fdw geometry support

View Trackers | Feature Requests | Download .csv | Monitor

Date:
2013-02-10 11:43
Priority:
3
State:
Closed
Submitted by:
Ragnar Ziugand (ragnar)
Assigned to:
Laurenz Albe (albe)
Category:
Data type support
Group:
Next Release
Summary:
Oracle_fdw geometry support

Detailed description
CREATE FOREIGN TABLE TABLE_NAME (
id numeric,
nd_id numeric,
area decimal,
geom geometry)
SERVER oracle_server
OPTIONS ( schema 'SHEMA', table 'TABLE');

ERROR: column "geom" of foreign table "TABLE" cannot be converted to from Oracle data type

Firstly, thanks for this epic extension that really works. But sadly it doesn't support Postgis data types yet. I would really like to use geometry conversion (wkt->wkb from oracle to postgres). IF more information is needed, please contact me.

Followup

Message
Date: 2013-05-21 12:36
Sender: Laurenz Albe

I'll close this because I received no response.
Date: 2013-02-22 15:41
Sender: Laurenz Albe

Sadly, I don't know much about PostGIS or Oracle Spatial.

oracle_fdw does its work by using PostgreSQL's type input functions on the text representation of the Oracle data values.

If the textual or binary representations of the geometrical values don't match, oracle_fdw would have to convert them somehow.
Do you have any idea how that could be done?

Yours,
Laurenz Albe

Attached Files:

Changes:

Field Old Value Date By
status_idOpen2013-05-21 12:36albe
close_dateNone2013-05-21 12:36albe
assigned_tonone2013-02-22 15:41albe
Powered By FusionForge