Skip to main content
Solved

Reading the Postgresql data

mario_bla
Participant
Forum|alt.badge.img+6

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!

 

 

Best answer by david_r

mario_bla wrote:

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.

View original
Did this help you find an answer to your question?

4 replies

david_r
Celebrity
  • david_rCelebrity
  • August 9, 2022

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?

mario_bla
Participant
Forum|alt.badge.img+6
  • mario_blaParticipant
  • Author
  • Participant
  • August 10, 2022

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.

mario_bla
Participant
Forum|alt.badge.img+6
  • mario_blaParticipant
  • Author
  • Participant
  • August 10, 2022

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!

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • August 10, 2022
mario_bla wrote:

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


Helpful Members This Week

Community Stats

31,370
Posts
118,973
Replies
39,000
Members

Latest FME

Terms & ConditionsCookie settings

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.