Question

Workbench hangs trying to convert Oracle BLOB to PostGIS bytea

  • 31 July 2015
  • 1 reply
  • 1 view
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
Rank
Userlevel 4
Badge +13

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


Community Stats

28,650
Posts
109,263
Replies
36,523
Members
Terms & ConditionsCookie 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.