Summary
Activity
Forums
Tracker
Lists
Tasks
Docs
Surveys
News
SCM
Files

[#1011303] Oracle_fdw geometry support

View Trackers | Feature Requests | Download .csv | Monitor

Date:
2013-02-10 11:43		 Priority:
3
State:
Open
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-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
assigned_tonone2013-02-22 15:41albe
Powered By FusionForge