Skip to main content
  • EN

Hello!

 

I have a problem while trying to read the data from postgresql (I'm not an expert).

Everything seems fine with database connection (test is successful - also I'm able to connect with the same parameters from psql).

The reader is created, I can see the attributes of chosen postgresql table.

Everything goes well until I hit the RUN button.

Then I get two types of errors:

 

  1. Error executing SQL command ('SELECT c.relhasoids AS oids FROM pg_class...
  2. Error executing SQL command ('declare "public_xxxxx_crsr" cursor...

 

Does anybody have some experience with this and can share some guidance.

 

Thanks in advance!

 

 

Which version of FME and which version of Postgresql are you running? Also, if you're using the Postgis reader in FME, has Postgis been installed on your Postgresql instance?

Versions are:

Postgresql is 12.6

Postgis 3.2.2

FME 2019.2

 

I was using postgresql reader, not the postgis reader. Postgis is installed but there is currently no spatial data in the database.

Hm... I installed latest FME 2022 and now everything works. It seems there is some problem with postgresql reader in version 2019.2.

 

Thanks for the idea!

Hm... I installed latest FME 2022 and now everything works. It seems there is some problem with postgresql reader in version 2019.2.

 

Thanks for the idea!

Indeed, I believe FME 2019 isn't fully compatible with Postgres 12.

Reply


Community Stats

30,162
Posts
114,510
Replies
37,819
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.