parallel query in 9.6.6 + oracle_fdw -> ERROR: invalid cache ID: 41

[ghost]

Hi,

I've found a problem in either PostgreSQL 9.6.6 or oracle_fdw 2.0.0. I've posted the details
on the Postgres general mailing list and a link here:

https://www.postgresql.org/message-id/96420364a3d055172776752a1de80714%40smtp.hushmail.com

Let me know if there's any additional tests I can do...

Thanks :)
Chris.

[ghost]

Replying to myself:

apparently the problem is in oracle_fdw.c, where _PG_init() calls SearchSysCacheList() - see
Tom Lane's reply:

https://www.postgresql.org/message-id/11960.1511116873%40sss.pgh.pa.us

Thanks :)
Chris.

[laurenz]

Thanks for the report; as usual, Tom's analysis was correct.

Could you test if commit 4accfeb fixes the problem for you?

[ghost]

Great!

I'll be able to test this only later today and will report back...

Thanks :)
Chris.

[ghost]

Hi,

here I am!

I've compiled the Github master, redone my tests and can confirm that
commit 4accfeb fixes the reported bug.

Thanks :)
Chris.

[laurenz]

Thanks for testing.