Skip to main content
Question

Workbench hangs trying to convert Oracle BLOB to PostGIS bytea

  • July 31, 2015
  • 1 reply
  • 13 views
T
I have pdf files stored as a blob in Oracle (11.2). I am trying to convert to PostGIS (9.3) bytea.  The tables gets created when running the workbench but the records fail to be written and the workbench hangs - no error and does not complete. The workbench does complete if i exclude the blob column. I have the same results if i use the PostGRES writer. Uinsg FME 2014.

1 reply

fmelizard
Safer
Forum|alt.badge.img+19
  • fmelizardSafer
  • Safer
  • May 17, 2016

Slow writing of data as bytea with the PostGIS Writer is a known issue in FME. Development is working on improving it as PR# 57164.

Reply


Helpful Members This Week

Community Stats

31,525
Posts
119,505
Replies
39,151
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.